动态SQL
create procedure proc_aa
@tabname varchar(20)
as
declare @s varchar(1000)
set @s='select * from '+ @tabname + ' where FeeType=1'
exec(@s)
go
create procedure proc_aa
@tabname varchar(20)
as
declare @s varchar(1000)
set @s='select * from '+ @tabname + ' where FeeType=1'
exec(@s)
go
要使用变量,必须使用execute
例如:
declare @t varchar(100)
set @t ='tablename'
exec('select * from ' + @t )