问StoredprocedureinMSSQLtoMySQL

EN

     ALTER PROCEDURE uspGetProductDetailsCSV (
            @sku NVARCHAR(MAX)
        )
        AS
        BEGIN
            -

            SELECT T.C.value('.', 'NVARCHAR(100)') AS [SKU]
            INTO #tblPersons
            FROM (SELECT CAST ('<Name>' + REPLACE     (@sku, ',', '</Name><Name>') 
            + '</Name>' AS XML) AS [Products]) AS A
            CROSS APPLY Products.nodes('/Name') as T(C)

            SELECT *
            FROM ProductInformation Pr
            WHERE EXISTS (SELECT Name FROM #tblPersons tmp WHERE tmp.SKU  
                           = case when len(tmp.SKU) = 11 then Product_No+Colour_Code+Size_Code
                                  when len(tmp.SKU) = 8 then Product_No+Colour_Code
                                  when len(tmp.sku) = 6 then Product_No end)



            DROP TABLE #tblPersons
        END