且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在sql server 2008示例中查询行的更新顺序

更新时间:2023-01-28 17:33:32



我也没听清楚这个问题.

如果要更新列,则该语句将类似于:

Hi,

I didnt get the question as well.

if you want to update a column than the statement would be something like:

UPDATE myTable
SET mycol=myvalue, mycol2=myvalue2,...
WHERE mycol*=anyvalue



如果您只想对col进行排序而不是使用:



if you just want to sort a col than use:

SELECT mycol
FROM mytable
ORDER BY mycol*