获取字段名函数

[luisic]

获取表中每一字段名称

Create function sp_getfiled(@tbname char(20))
returns varchar(8000)
as
begin
declare @filedname char(20)
declare @result varchar(8000)
set @result=''
set @filedname=''
declare filedname_cursor CURSOR FOR select name from syscolumns where id=(select id from sysobjects where name=@tbname)
open filedname_cursor
FETCH NEXT FROM filedname_cursor into @filedname
WHILE @@FETCH_STATUS = 0
BEGIN
set @result=@result+replace(@filedname,' ','')+','
FETCH NEXT FROM filedname_cursor into @filedname
END
CLOSE filedname_cursor
DEALLOCATE filedname_cursor
return left(@result,len(@result)-1)
end

[Limpire]

呵呵，楼主辛苦了！

[xueguang]

游标可以不用的

Create function sp_getfiled(@tbname char(20))
returns varchar(8000)
as
begin
declare @result varchar(8000)
set @result=''
select @result=@result+','+name from syscolumns where id=object_id(@tbname) order by colorder
return stuff(@result,1,1,'')
end

[leo_lesley]

好贴 顶~~~

[luisic]

顶