摘要： 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... 阅读全文

摘要： 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... 阅读全文

摘要： 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... 阅读全文

摘要： if exists (select 1 from sysobjects where id = object_id('tb_Menu') and type = 'U') drop table tb_Menugo/*==============================================================*//* Table: tb_Menu *//*========================... 阅读全文

摘要： if exists (select 1 from sysobjects where id = object_id('tb_Menu') and type = 'U') drop table tb_Menugo/*==============================================================*//* Table: tb_Menu *//*========================... 阅读全文