CREATE proc getTable (@tabl varchar(360))
as
begin
declare @Str varchar(360)
set @Str=''
select @Str=@Str+[name]+',' from syscolumns where id=object_id(@tabl) order by colid
set @Str = substring(@Str,0,len(@Str))
print @Str
end
GO
posted on 2010-10-16 11:14
sanmao 閱讀(83)
評論(0) 編輯 收藏