收藏几段SQL Server语句和存储过程

  '''NULL'''
end as col,a.colid,a.name
from syscolumns a where a.id = object_id(@tablename) and a.xtype <>189 and a.xtype <>34 and a.xtype <>35 and a.xtype <>36
)t order by colid

select @sqlstr=@sqlstr left(@sqlstr2,len(@sqlstr2)-1) ') ' left(@sqlstr1,len(@sqlstr1)-3) ')'' from ' @tablename
-- print @sqlstr
exec( @sqlstr)
set nocount off
end

共16页: 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] 16 下一页

评论加载中…