如何使用RowNumber（）编写更新查询... [英] How to write update query using RowNumber()...

问题描述

大家好，



请认真对待这个问题并尽快帮助我...等待你的回答..



更新Tbl_Doc_Stock_Chem_Add_Mst设置C_Code ='C06315'+ ROW_NUMBER（）结束（按c_name排序）



得到错误如



消息4108，等级15，状态1，行1

窗口函数只能出现在SELECT或ORDER中BY子句。

Hi Guys,

Please take this problem seriously and help me out as soon as possible..am eagerly waiting for your answer..

update Tbl_Doc_Stock_Chem_Add_Mst set C_Code='C06315'+ROW_NUMBER() over (order by c_name)

getting error like

Msg 4108, Level 15, State 1, Line 1
Windowed functions can only appear in the SELECT or ORDER BY clauses.

推荐答案

试试这个：

Try this:

UPDATE  Tbl_Doc_Stock_Chem_Add_Mst
SET     C_Code = NewNum
FROM
(
    SELECT  C_Code, 'C06315' + CONVERT(VARCHAR(MAX), ROW_NUMBER()  OVER (ORDER BY c.name)) AS NewNum
    FROM   Tbl_Doc_Stock_Chem_Add_Mst  c
) AS table1 WHERE table1.C_Code=Tbl_Doc_Stock_Chem_Add_Mst.C_Code;
select * from Tbl_Doc_Stock_Chem_Add_Mst

这篇关于如何使用RowNumber（）编写更新查询...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！