SQL 多字段复制行

SQL 多字段复制行

----项目 
set @tab_name='MDS_Project'
DECLARE @NewProjectVersionID VARCHAR(50)=NEWID();
set @columns=''
select @columns=@columns+ name + ',' from syscolumns where id=object_id(@tab_name) and NAME NOT IN ('ProjectVersionID')
set @columns=left(@columns,len(@columns)-1)
exec ('insert into '+@tab_name+' select ''' +@NewProjectVersionID+''','+@columns + ' from ' + @tab_name+' where ProjectVersionID='''+@ProjectVersionID+'''') 
  
 --SELECT * FROM MDS_Project 
 -- DELETE FROM MDS_Project WHERE ProjectVersionID='280532E9-D8AC-42D7-9D4F-40F1CBF4AEA1'
  
UPDATE MDS_Project SET ProjectVersion = ProjectVersion+1,ApproveStatus = 0,[Status] = 1 WHERE ProjectVersionID= @NewProjectVersionID