How to create view using stored procedure

Posted by Hariinakoti under Sql Server category on 9/13/2012 | Points: 40 | Views : 2624

Post Code |

Search Codes |

Code Home

create proc CreateView
as
begin
Declare @SQL varchar(max)
set @SQL ='create view TEST1 as Select * from sys.tables'
exec(@SQL)
end

run the storedprocedure: EXEC CreateView

Alert Moderator

Bookmark It

Comments or Responses

Posted by: Jasminej on: 9/15/2012 Level:Starter | Status: [Member] | Points: 10

What will happen If I run the Procedure again and again ?

Posted by: T.Saravanan on: 9/15/2012 Level:Silver | Status: [Member] [MVP] | Points: 10

Hi Hari,

Nice question from Jasminej. Please update your proc as rerunable and also post your code inside the code tag.

Latest Code Snipptes

Uber Clone - Taxi Booking App
writing Custom pagination html code in python and django
Code snippet for setInterval
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
More ...