27,579
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO Main
(
SELECT
newID AS col1,
val2-modified AS col2,
val3-modified AS col3,
col4,
col5,
...
...
col99,
col100,
col101,
...
)
IF OBJECT_ID('A') IS NOT NULL DROP TABLE A
GO
SELECT * INTO A FROM MAIN
UPDATE A SET COL2=COL2-modified,COL3=COL3-modified
INSERT INTO MAIN
SELECT * FROM A
DROP TABLE A
declare @cols varchar(8000)
select @cols = isnull(@cols+',', '')+name from syscolumns where id = object_id('table_name') order by colid
print @cols
declare @sql varchar(8000)
select @sql=isnull(@sql+',','')+name from syscolumns where id=object_id('Main')
print @sql --这里得到的就是所有的列
set @sql='insert into main select '+@sql---这里继续做你要做的操作