22,300
社区成员




ALTER PROCEDURE dbo.查询存储过程
@ym int,
@tablename varchar(20)
AS
declare @sqlstr varchar(1000)
set @sqlstr='select EmpID,SubID,Amount,' + cast(@ym as varchar(10)) + ' into #temptable from ' + @tablename
exec(@sqlstr)
ALTER PROCEDURE dbo.查询存储过程
@ym int,
@tablename varchar(20)
AS
declare @sqlstr varchar(1000)
set @sqlstr='select EmpID,SubID,Amount,' + @ym + ' into #temptable from ' + @tablename
exec(@sqlstr)
ALTER PROCEDURE dbo.查询存储过程
@ym int,
@tablename varchar(20)
AS
decalre @sqlstr varchar(1000)
set @sqlstr='select EmpID,SubID,Amount,' + @ym + ' into #temptable from ' + @tablename
exec(@sqlstr)