有时候需要将所有的列名相加后作表单insert,update用,但如果一个表的列太多的话,一一列出来很不方便,用程序自动加起来,其实很快.
declare @colname nvarchar(50)
declare @allcolname nvarchar(1000)
declare mycursor cursor for select name from syscolumns where id=object_id('Customer') order by colid
open mycursor
fetch next from mycursor into @colname
while(@@fetch_status=0)
begin
if(@allcolname is null)
set @allcolname=@colname+','
else
set @allcolname=@allcolname+@colname+','
fetch next from mycursor into @colname
end
close mycursor
deallocate mycursor
print @allcolname
请注意if语句,否则你得出的是空
