|
|
|
Old Hand
 
Group: General Forum Members
Last Login: 2 days ago @ 3:10 AM
Points: 326,
Visits: 385
|
|
when i execute the following procedure after creating it i am getting error below.
"alter proc usp_get
as
begin
declare @sql varchar(100)='create view dbo.vw_select as select '+char(39)+'2009-01-01'+Char(39)+' As a'
print @sql
exec @sql
end
go"
exec usp_get
Error Msg
Msg 2812, Level 16, State 62, Procedure usp_get, Line 6
Could not find stored procedure 'create view dbo.vw_select as select '2009-01-01' As a'.
Help?
I am created procedure which creates a view in it
Regards
Ramu
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 1,219,
Visits: 3,099
|
|
Hi,
Try this
alter proc usp_get
as
begin
declare @sql Nvarchar(100)
select @sql = 'create view dbo.vw_select as select '+char(39)+'2009-01-01'+Char(39)+' As a'
print @sql
exec sp_executesql @sql
end
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 3:10 AM
Points: 326,
Visits: 385
|
|
Thanks it worked.
arun.sas (8/17/2009)
Hi, Try this alter proc usp_get
as
begin
declare @sql Nvarchar(100)
select @sql = 'create view dbo.vw_select as select '+char(39)+'2009-01-01'+Char(39)+' As a'
print @sql
exec sp_executesql @sql
end
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 2:27 PM
Points: 3,003,
Visits: 1,844
|
|
yet another way to skin the cat - no sp_executesql
alter proc usp_get
as
begin
declare @sql varchar(100)
select @sql='create view dbo.vw_select as select '+char(39)+'2009-01-01'+Char(39)+' As a'
print @sql
exec (@sql)
end
go
exec usp_get
Regards
Rudy Komacsar
Senior Database Administrator
"Ave Caesar! - Morituri te salutamus."
|
|
|
|
