有一存储过程如下create proc test
@a int
as
declare @sql varchar(1000)
set @sql='create view myview as select * from tb where id=@a'
exec(@sql)请问哪出错了???
@a int
as
declare @sql varchar(1000)
set @sql='create view myview as select * from tb where id=@a'
exec(@sql)请问哪出错了???
@a int
as
declare @sql varchar(1000)
set @sql='create view myview as select * from tb where id= '+ @aexec(@sql)
exec test 1 运行时还是出错
CREATE proc test
@a int
as
declare @sql varchar(1000)
set @sql='create view myview as select * from tb where id=' +CAST(@a AS VARCHAR)
exec(@sql)