摘要:
ALTER FUNCTION [dbo].[ChangeCharToTable](@InStatement NVARCHAR(MAX))RETURNS @InTable TABLE ( Id int not null primary key clustered)ASBEGIN DECLARE @XML as xml set @XML='<t><i>' + REPLACE(@InStatement,',','</i><i>') + '</i></t>' INSE 阅读全文
摘要:
CREATE TABLE table1(SELECT ecuserid,id,PartnerType FROM table2 WHERE PartnerType=4 AND createdate BETWEEN '2011-09-23' AND '2011-10-10')UPDATE ecuser_cooperationuser AS aLEFT JOIN ecuser_customer b ON a.KubaUserId = b.EcUserIdSET b.PartnerType = 2WHERE a.Platform='彩贝'SELECT C 阅读全文