22,210
社区成员
发帖
与我相关
我的任务
分享
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)