摘要:
二分 Code -- =============================================-- Author: <jason,cheng>-- Create date: <2012-9-24>-- Description: <通用存储过程分页[二分处理]>-- ExcuteDemo:exec UP_paged_2part_selectMax 'tb_testTable','ID,userName,userPWD,userEmail',10,100000,'ID',0,null,'I
阅读全文
posted @ 2012-10-22 16:59
Jasoncheng
阅读(184)
推荐(0)
编辑
摘要:
Splite Code SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate FUNCTION [dbo].[Fun_split_string](@s varchar(2000), --待分拆的字符串@split varchar(10) --数据分隔符)RETURNS @re TABLE(col varchar(100))ASBEGIN DECLARE @splitlen int SET @splitlen=LEN(@split+'a')-2 WHILE CHARINDEX(@split,@s)>0 BE...
阅读全文
posted @ 2012-10-22 16:56
Jasoncheng
阅读(242)
推荐(0)
编辑
摘要:
Create Insert Code CREATE PROCEDURE dbo.UspOutputData @tablename sysname AS declare @column varchar(1000) declare @columndata varchar(1000) declare @sql varchar(4000) declare @xtype tinyint declare @name sysname declare @objectId int declare @objectname sysname declare @ident int set nocount on set
阅读全文
posted @ 2012-10-22 16:54
Jasoncheng
阅读(214)
推荐(0)
编辑