Tag: 拆分字符串
sql server存储过程拆分字符串方法
unvs | ASP.NET | 2011-09-26
ALTER PROCEDURE dbo.[Spilt] @str varchar(100),@str2 varchar(100) AS declare @id1 int,@id2 int while patindex(‘%,%’,@str)>0 begin set @id1 = CONVERT(int,substring(@str,1,PATINDEX(‘%,%’,@str)-1))set @id2... [阅读全文]