declare
@sql nvarchar(1000),
@Table nvarchar(30),
@Fields1 nvarchar(30),
@Fields2 nvarchar(30),
@Temp nvarchar(30),
@ID int set @sql=N'select @F2=' + @Fields2+N' from ' +@Table
+ N' where ' +@Fields2+ N' = @N' exec sp_executesql @sql,
N'@F2 nvarchar(30) out,@N nvarchar(30)',@Temp out,@strName 动态SQL
@sql nvarchar(1000),
@Table nvarchar(30),
@Fields1 nvarchar(30),
@Fields2 nvarchar(30),
@Temp nvarchar(30),
@ID int set @sql=N'select @F2=' + @Fields2+N' from ' +@Table
+ N' where ' +@Fields2+ N' = @N' exec sp_executesql @sql,
N'@F2 nvarchar(30) out,@N nvarchar(30)',@Temp out,@strName 动态SQL
create procedure
@tab char(100)
as
declare @sql nvarchar(100)
select @sql = 'select * from ' + @tab
exec(@sql)