我怎样才能将这个MySQL代码转换为SQL Server [英] how can i convert this MySQL code to SQL Server

问题描述

大家好吧

我们在SQL服务器中合并时合并到函数中，例如

Hi everyone
We have in SQL server WHEN MATCHED THEN in Merge into function for example

MERGE INTO Table_ResidVaSell as ResidVaSell
       USING (
              Select Top 1 IDMavad,EndDayTank From Table_Total as Select1 where Tarikh<=@DateTo and IDMavad=1 order by Tarikh Desc
              union
              Select Top 1 IDMavad,EndDayTank From Table_Total as Select2 where Tarikh<=@DateTo and IDMavad=2 order by Tarikh Desc
              union
              Select Top 1 IDMavad,EndDayTank From Table_Total as Select3 where Tarikh<=@DateTo and IDMavad=3 order by Tarikh Desc
              ) AS source
       ON ResidVaSell.IDMavad=source.IDMavad
    WHEN MATCHED THEN
    UPDATE SET
    EndDayTank=source.EndDayTank;

现在如何将其转换为MySQL代码？

谢谢。

Now how can i convert it to MySQL Code?
Thank you.

推荐答案

看看这里：如何将此代码从SQL服务器转换为MYSQL [ ^ ]



下次，请使用 SearchBox [ ^ ]

Have a look here: How can i Convert this code from SQL server to MYSQL[^]

Next time, please use SearchBox[^]

这篇关于我怎样才能将这个MySQL代码转换为SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！