2014年2月24日

Trigger,Cursor

摘要: USE [Demo]GO/****** Object: StoredProcedure [dbo].[p_couser_Student] Script Date: 02/24/2014 20:43:16 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--Student insert trigger update Class C_COUNT--create trigger tr_I_Student--on Student--for insert--as--begin-- update Class set C_Count=C_Cou... 阅读全文

posted @ 2014-02-24 21:03 君凌 阅读(247) 评论(0) 推荐(0)

Paging

摘要: USE [Demo]GO/****** Object: StoredProcedure [dbo].[sp_Page] Script Date: 02/19/2014 21:26:34 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--declare @TotalCount int--exec Page 8,0,'S_Name','desc','%周%','',@TotalCount output--select @TotalCountALTER proc [dbo].[s 阅读全文

posted @ 2014-02-24 21:01 君凌 阅读(227) 评论(0) 推荐(0)

导航