随笔分类 -  sqlserver2008

触发器--里面涉及触发器调存储过程
摘要:if (object_id('TR_EMP_CHANGE_USRA91', 'TR') is not null) drop trigger TR_EMP_CHANGE_USRA91gocreate trigger TR_EMP_CHANGE_USRA91on USRA91AFTER DELETE,I... 阅读全文

posted @ 2015-10-23 16:19 struggle_beiJing 阅读(227) 评论(0) 推荐(0)

存储过程
摘要:一个简单存储过程例子CREATEPROCEDUREsp_cpsum_bylevel1ASbegindeclare@codevarchar(50)declare@numvarchar(50)declare@commandvarchar(1000)declarecursor_tmp_1cursorfor... 阅读全文

posted @ 2015-10-23 16:15 struggle_beiJing 阅读(205) 评论(0) 推荐(0)

导航