Code Snippet posted by:
Hariinakoti | Posted on: 9/13/2012 | Category:
SQL Server Codes | Views: 605 | Status:
[Member] |
Points: 40
|
Alert Moderator
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
Thanks & Regards
Hari
Found interesting? Add this to: