34,588
社区成员
发帖
与我相关
我的任务
分享
--像这样的应用,只能拼SQL
DECLARE @listname1 NVARCHAR(255), @listname2 NVARCHAR(255), @listname3 NVARCHAR(255)
DECLARE @ID INT, @dateshed1 VARCHAR(100)
DECLARE @sql NVARCHAR(MAX)
SET @sql=N'
INSERT INTO Tc_Pomain_shed_bydate (ID,{listname1},{listname2},{listname3})
VALUES (@ID,@dateshed1,@dateshed1,@dateshed1)
'
SET @sql = REPLACE(@sql, '{listname1}', @listname1)
SET @sql = REPLACE(@sql, '{listname2}', @listname2)
SET @sql = REPLACE(@sql, '{listname3}', @listname3)
--print @sql
EXEC sp_executesql @sql, N'@ID int,@dateshed1 varchar(100)', @dateshed1
declare @sql nvarchar(4000),@row INT,@listname VARCHAR(20),@dateshed2 DECIMAL(18,2),@id INT
set @sql=''
SET @row = 2
SET @listname = 'dateshed' + RTRIM(CAST(@row AS VARCHAR(2)))
SET @ID = 2
SET @dateshed2 = 2.2
set @sql='INSERT INTO Tc_Pomain_shed_bydate (ID,'+@listname+')
VALUES ('+cast(@ID as varchar)+','+cast(@dateshed2 as varchar)+')'
print @sql
exec @sql