SQL SERVER导出所有表及表字段
/*Goal：MS SQL SERVER：Output all the field and its’ table
author:AllisonHuang
created date :20140613
*/
--select , from where = 'u' order by
drop table#temping
create table #temping (id varchar(200),name varchar(200),namedetail varchar(200))
--SELECT name,id FROM SysColumns WHERE id=Object_Id('ABUSEDSTOCK')
declare @id varchar(20)
declare @name varchar(20)
declare cursor1 cursor for --定义游标cursor1
select , from where = 'u' order by
open cursor1 --打开游标
fetch next from cursor1 into @id,@Name --将游标向下移行，获取的数据放入之前定义的变量@id,@NUM中
while @@fetch_status=0 --判断是否成功获取数据
begin
insert into#temping
SELECT id,@name,name FROM SysColumns WHERE id=Object_Id(@Name)
--id is Object_Id(@Name)'s id ,not 's.
fetch next from cursor1 into @id,@Name--将游标向下移行
end
close cursor1 --关闭游标
deallocate cursor1
select * from #temping
页:
[1]