摘要: set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[PRO_PAGEDATA]/****************************************************************** 千万数量级分页存储过程 *****************************************************************参数说明:1.Tables :表名称,视图2.PrimaryKey :主关键字3.Sort :排序语句,不带Order By 比如:NewsID D.. 阅读全文
posted @ 2011-09-22 23:32 cxfzxj9898 阅读(238) 评论(0) 推荐(0)
摘要: set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[PRO_TICKETNUMBER]( @tablename varchar(20), --表名 @outnumber varchar(20) output --返回值)ASbegin DECLARE @SIGNNAME NVARCHAR(20) DECLARE @NUMBER NVARCHAR(20) DECLARE @TODAY NVARCHAR(20) DECLARE @YESTODAY VARCHAR(20) DECLARE @DAYS... 阅读全文
posted @ 2011-09-22 23:28 cxfzxj9898 阅读(219) 评论(0) 推荐(1)