火焰

摘要：select stuff(RTRIM(Convert(varchar(max),(SELECT distinct ','+sku FROM AmazonSellingList where AmazonStatus!='Deleted' FOR XML PATH('')))),1,1,'')Vie... 阅读全文

摘要：ALTER function [dbo].[fun_split](@SourceSql nvarchar(max),@StrSeprate varchar(10))returns @temp table(SplitValue nvarchar(500))--功能: 实现split的函数--用法：select * from dbo.fun_split('ABC:BC:C:D:E',':') as begin DECLARE @i INT, @tmpStr VARCHAR(100) SET @i = CHARINDEX(@StrSeprate, @SourceSql 阅读全文