摘要: create function [dbo].[f_getcolsByName](@tableName varchar(50)) returns varchar(1000)asbegin declare @cols varchar(1000) select @cols='' select @cols+=name+',' from syscolumns where id=OBJECT_ID(@tableName) if @cols'' begin select @cols=SUBSTRING(@cols,1,len(@cols) -1) end re 阅读全文
posted @ 2013-09-28 15:09 kuailewangzi1212 阅读(400) 评论(0) 推荐(0) 编辑