摘要：USE [chy]GO/****** Object: StoredProcedure [dbo].[list_page] Script Date: 02/27/2014 14:30:04 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================declare @count int exec list_page ' z_username, z_sonusername, z_sonScore, z_getMoney, ServerNo, shouk 阅读全文

摘要：ALTER function [dbo].[f_split](@c varchar(2000),@split varchar(2)) returns @t table(col varchar(20),id int identity) as begin while(charindex(@split,@c)0) begin insert @t(col) values (substring(@c,1,charindex(@split,@c)-1)) set @c = stuff(@c,1,charindex(@split,@c),'') end insert @t(col) valu 阅读全文