程序之路

[code="java"][color=darkblue] 查询表结构信息 SELECT code,name, tree_link,precode,cast(srt as varchar) orders, 1 AS [Level] FROM ( select t.ID code, T.NAME, T.MENUTYPE, T.URL tree_link, T.PARENTID precode...

declare @tab varchar(20) while exists(select * from sysobjects where xtype='u') begin select top 1 @tab=name from sysobjects where xtype='u' exec('drop table '+@tab) end 删除当前数据库中的所有表 ...