if exists( select 1 from sysobjects where name = 'fn_get_all_columns')
drop function fn_get_all_columns
go
Create Function fn_get_all_columns (@table_name varchar(50))
returns varchar(max)
as
begin
declare @rtn varchar(max)
select @rtn = case when @rtn is null then name
else @rtn +','+ name
end
from sys.columns
where object_id = object_id(@table_name)
--print @rtn
return @rtn
end
转载请注明原文地址: https://ju.6miu.com/read-1124749.html
