摘要：
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tg_user_add]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[tg_user_add] GO if exists (select * from dbo.sysobje... 阅读全文
摘要：
/*output的應用*/ CREATE PROCEDURE [dbo].[sp_output] ( @i char(1)='1', @a varchar(5)=null output ) AS begin if(@i='1') set @a='aaaaa' else set @a='bbbbb' end GO /*存儲過程內調用*/ CREATE PRO... 阅读全文