declare
@col
varchar
(
5000
)
set @col = '' ;
select @col = @col + convert ( varchar ( 15 ),a.d, 107 ) + ' , ' from
( select name as d from syscolumns where id = object_id ( ' listdata ' ) and name not in ( ' listid ' )) as a
print left ( @col , len ( @col ) - 1 )
通过这种做法,我把listdata里面除了listid里的列全部选出来,并整理成如下格式
id,subject,creator,createTime,creatorName,createOU,creatorOUName,modifier,modifierName,modifierOU,modifierOUName,lastModify,varchar1, varchar2 ,varchar3,varchar4,varchar5,varchar6,varchar7,varchar8,varchar9,varchar10,varchar11,varchar12,varchar13,varchar14,varchar15,varchar16,varchar17,varchar18,varchar19,varchar20,varchar21,varchar22,varchar23,varchar24,varchar25,varchar26,varchar27,varchar28,varchar29,varchar30,number1,number2,number3,number4,number5,number6,number7,number8,number9,number10,number11,number12,number13,number14,number15,number16,number17,number18,number19,number20,number21,number22,number23,number24,number25,number26,number27,number28,number29,number30,date1,date2,date3,date4,date5,date6,date7,date8,date9,date10,date11,date12,date13,date14,date15,date16,text1,text2,text3,text4,text5,text6,text7,text8,text9,text10,text11,text12,text13,text14,text15,text16,seqforseatch
所以对于列超长时非常有用
set @col = '' ;
select @col = @col + convert ( varchar ( 15 ),a.d, 107 ) + ' , ' from
( select name as d from syscolumns where id = object_id ( ' listdata ' ) and name not in ( ' listid ' )) as a
print left ( @col , len ( @col ) - 1 )
通过这种做法,我把listdata里面除了listid里的列全部选出来,并整理成如下格式
id,subject,creator,createTime,creatorName,createOU,creatorOUName,modifier,modifierName,modifierOU,modifierOUName,lastModify,varchar1, varchar2 ,varchar3,varchar4,varchar5,varchar6,varchar7,varchar8,varchar9,varchar10,varchar11,varchar12,varchar13,varchar14,varchar15,varchar16,varchar17,varchar18,varchar19,varchar20,varchar21,varchar22,varchar23,varchar24,varchar25,varchar26,varchar27,varchar28,varchar29,varchar30,number1,number2,number3,number4,number5,number6,number7,number8,number9,number10,number11,number12,number13,number14,number15,number16,number17,number18,number19,number20,number21,number22,number23,number24,number25,number26,number27,number28,number29,number30,date1,date2,date3,date4,date5,date6,date7,date8,date9,date10,date11,date12,date13,date14,date15,date16,text1,text2,text3,text4,text5,text6,text7,text8,text9,text10,text11,text12,text13,text14,text15,text16,seqforseatch
所以对于列超长时非常有用