随笔分类 -  sql server

sql server 分页存储过程
摘要：USE [instrument] GO /****** Object: StoredProcedure [dbo].[sp_PageView] Script Date: 11/17/2017 17:02:34 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO ALTER PROC [dbo].[sp_PageVie... 阅读全文

posted @ 2017-11-17 17:10 潺潺水声 阅读(176) 评论(0) 推荐(0)

触发器--单独字段变化另一个字段也变化
摘要：USE [nmgdl]GO/****** Object: Trigger [dbo].[trg_NonExamCourse] Script Date: 02/28/2015 11:31:02 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ON... 阅读全文

posted @ 2015-02-28 16:45 潺潺水声 阅读(261) 评论(0) 推荐(0)

导航