摘要： 二分 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 阅读全文

摘要： 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... 阅读全文

摘要： 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 阅读全文