摘要:
if exists (select 1 from sysobjects where id = object_id('tb1') and type = 'U') drop table tb1gocreate table tb1 ( Id int null, name varchar(50) null, pId int nul...
阅读全文
posted @ 2013-11-29 18:31
朝着
阅读(364)
推荐(0)
编辑
摘要:
if exists (select * from sysobjects where name='proc_menu_select')drop procedure proc_menu_selectgocreate proc proc_menu_select(@id int,@t int)as declare @i int declare @count int, @tmpid int create table #tb(id int,name varchar(50),pId int,level int,sort int) select @count=COUNT(1) fro...
阅读全文
posted @ 2013-11-29 18:16
朝着
阅读(319)
推荐(0)
编辑