久久久久久久av_日韩在线中文_看一级毛片视频_日本精品二区_成人深夜福利视频_武道仙尊动漫在线观看

<i id='YXaAA'><tr id='YXaAA'><dt id='YXaAA'><q id='YXaAA'><span id='YXaAA'><b id='YXaAA'><form id='YXaAA'><ins id='YXaAA'></ins><ul id='YXaAA'></ul><sub id='YXaAA'></sub></form><legend id='YXaAA'></legend><bdo id='YXaAA'><pre id='YXaAA'><center id='YXaAA'></center></pre></bdo></b><th id='YXaAA'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='YXaAA'><tfoot id='YXaAA'></tfoot><dl id='YXaAA'><fieldset id='YXaAA'></fieldset></dl></div>
    • <bdo id='YXaAA'></bdo><ul id='YXaAA'></ul>
    <legend id='YXaAA'><style id='YXaAA'><dir id='YXaAA'><q id='YXaAA'></q></dir></style></legend>

    1. <small id='YXaAA'></small><noframes id='YXaAA'>

    2. <tfoot id='YXaAA'></tfoot>

      1. 嵌套計算列“無效的列名"錯誤(T-SQL 列別名

        Nested computed column quot;Invalid column namequot; error (T-SQL Column alias)(嵌套計算列“無效的列名錯誤(T-SQL 列別名))
      2. <tfoot id='dv5P9'></tfoot>
        • <i id='dv5P9'><tr id='dv5P9'><dt id='dv5P9'><q id='dv5P9'><span id='dv5P9'><b id='dv5P9'><form id='dv5P9'><ins id='dv5P9'></ins><ul id='dv5P9'></ul><sub id='dv5P9'></sub></form><legend id='dv5P9'></legend><bdo id='dv5P9'><pre id='dv5P9'><center id='dv5P9'></center></pre></bdo></b><th id='dv5P9'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='dv5P9'><tfoot id='dv5P9'></tfoot><dl id='dv5P9'><fieldset id='dv5P9'></fieldset></dl></div>

          • <bdo id='dv5P9'></bdo><ul id='dv5P9'></ul>
                <tbody id='dv5P9'></tbody>
            • <legend id='dv5P9'><style id='dv5P9'><dir id='dv5P9'><q id='dv5P9'></q></dir></style></legend>

                <small id='dv5P9'></small><noframes id='dv5P9'>

                  本文介紹了嵌套計算列“無效的列名"錯誤(T-SQL 列別名)的處理方法,對大家解決問題具有一定的參考價值,需要的朋友們下面隨著小編來一起學(xué)習(xí)吧!

                  問題描述

                  限時送ChatGPT賬號..

                  我創(chuàng)建了 3 個計算列作為別名,然后使用別名列來計算總成本.這是查詢:

                  I've create 3 computed columns as alias and then used the aliased columns to calculate the total cost. This is the query:

                  SELECT TOP 1000 [Id]
                        ,[QuantityOfProduct]
                        ,[Redundant_ProductName]
                        ,[Order_Id]
                        ,(CASE 
                              WHEN [PriceForUnitOverride] is NULL 
                                  THEN [Redundant_PriceForUnit]
                              ELSE
                                  [PriceForUnitOverride]
                          END
                          ) AS [FinalPriceForUnit]
                  
                        ,(CASE 
                              WHEN [QuantityUnit_Override] is NULL 
                                  THEN [Redundant_QuantityUnit]
                              ELSE
                                  [QuantityUnit_Override]
                          END
                          ) AS [FinalQuantityUnit]
                  
                        ,(CASE 
                              WHEN [QuantityAtomic_Override] is NULL 
                                  THEN [Redundant_QuantityAtomic]
                              ELSE
                                  [QuantityAtomic_Override]
                          END
                          ) AS [Final_QuantityAtomic]
                  
                           --***THIS IS WHERE THE QUERY CREATES AN ERROR***--
                          ,([QuantityOfProduct]*[FinalPriceForUnit]*
                    ([Final_QuantityAtomic]/[FinalQuantityUnit])) AS [Final_TotalPrice]
                  
                  
                    FROM [dbo].[ItemInOrder]
                  
                    WHERE [IsSoftDeleted] = 0
                    ORDER BY [Order_Id] 
                  

                  控制臺返回此錯誤消息:

                  The console returns this ERROR message:

                  Msg 207, Level 16, State 1, Line 55
                  Invalid column name 'FinalPriceForUnit'.
                  Msg 207, Level 16, State 1, Line 55
                  Invalid column name 'Final_QuantityAtomic'.
                  Msg 207, Level 16, State 1, Line 55
                  Invalid column name 'FinalQuantityUnit'.
                  

                  如果我刪除AS [Final_TotalPrice]"別名計算列,則不會發(fā)生錯誤,但我需要總價.我該如何解決這個問題?似乎在達(dá)到 Final_TotalPrice 時還沒有創(chuàng)建其他別名.

                  If I remove the "AS [Final_TotalPrice]" alias computed column, no error occurs, but I need the total price. How can I solve this issue? It seems as the other aliases have not been created when the Final_TotalPrice is reached.

                  推薦答案

                  不能在同一個選擇中使用表別名.正常的解決方案是 CTE 或子查詢.但是,SQL Server 也提供 APPLY.(Oracle 還支持 APPLY,其他數(shù)據(jù)庫(例如 Postgres)支持使用 LATERAL 關(guān)鍵字進(jìn)行橫向連接.)

                  You can't use table aliases in the same select. The normal solution is CTEs or subqueries. But, SQL Server also offers APPLY. (Oracle also supports APPLY and other databases such as Postgres support lateral joins using the LATERAL keyword.)

                  我喜歡這個解決方案,因為你可以創(chuàng)建任意嵌套的表達(dá)式而不必?fù)?dān)心縮進(jìn):

                  I like this solution, because you can create arbitrarily nested expressions and don't have to worry about indenting:

                  SELECT TOP 1000 io.Id, io.QuantityOfProduct, io.Redundant_ProductName,
                         io.Order_Id,
                         x.FinalPriceForUnit, x.FinalQuantityUnit, x.Final_QuantityAtomic,
                         (x.QuantityOfProduct * x.FinalPriceForUnit * x.Final_QuantityAtomic / x.FinalQuantityUnit
                         ) as Final_TotalPrice
                  FROM dbo.ItemInOrder io OUTER APPLY
                       (SELECT COALESCE(PriceForUnitOverride, Redundant_PriceForUnit) as FinalPriceForUnit,
                               COALESCE(QuantityUnit_Override, Redundant_QuantityUnit) as FinalQuantityUnit
                               COALESCE(QuantityAtomic_Override, Redundant_QuantityAtomic) as Final_QuantityAtomic
                       ) x
                  WHERE io.IsSoftDeleted = 0
                  ORDER BY io.Order_Id ;
                  

                  注意事項:

                  • 我發(fā)現(xiàn) [] 根本無法幫助我閱讀或編寫查詢.
                  • COALESCE() 比您的 CASE 語句簡單得多.
                  • 使用 COALESCE(),您可能會考慮只將 COALESCE() 表達(dá)式放入最終計算中.
                  • I don't find that [ and ] help me read or write queries at all.
                  • COALESCE() is much simpler than your CASE statements.
                  • With COALESCE() you might consider just putting the COALESCE() expression in the final calculation.

                  這篇關(guān)于嵌套計算列“無效的列名"錯誤(T-SQL 列別名)的文章就介紹到這了,希望我們推薦的答案對大家有所幫助,也希望大家多多支持html5模板網(wǎng)!

                  【網(wǎng)站聲明】本站部分內(nèi)容來源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問題,如果有圖片或者內(nèi)容侵犯了您的權(quán)益,請聯(lián)系我們刪除處理,感謝您的支持!

                  相關(guān)文檔推薦

                  Can I figure out a list of databases and the space used by SQL Server instances without writing SQL queries?(我可以在不編寫 SQL 查詢的情況下找出數(shù)據(jù)庫列表和 SQL Server 實例使用的空間嗎?) - IT屋-程序員軟件開發(fā)
                  How to create a login to a SQL Server instance?(如何創(chuàng)建對 SQL Server 實例的登錄?)
                  How to know the version and edition of SQL Server through registry search(如何通過注冊表搜索知道SQL Server的版本和版本)
                  Why do I get a quot;data type conversion errorquot; with ExecuteNonQuery()?(為什么會出現(xiàn)“數(shù)據(jù)類型轉(zhuǎn)換錯誤?使用 ExecuteNonQuery()?)
                  How to show an image from a DataGridView to a PictureBox?(如何將 DataGridView 中的圖像顯示到 PictureBox?)
                  WinForms application design - moving documents from SQL Server to file storage(WinForms 應(yīng)用程序設(shè)計——將文檔從 SQL Server 移動到文件存儲)

                  <small id='3Vzuf'></small><noframes id='3Vzuf'>

                      <tfoot id='3Vzuf'></tfoot>
                        <bdo id='3Vzuf'></bdo><ul id='3Vzuf'></ul>

                        <i id='3Vzuf'><tr id='3Vzuf'><dt id='3Vzuf'><q id='3Vzuf'><span id='3Vzuf'><b id='3Vzuf'><form id='3Vzuf'><ins id='3Vzuf'></ins><ul id='3Vzuf'></ul><sub id='3Vzuf'></sub></form><legend id='3Vzuf'></legend><bdo id='3Vzuf'><pre id='3Vzuf'><center id='3Vzuf'></center></pre></bdo></b><th id='3Vzuf'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='3Vzuf'><tfoot id='3Vzuf'></tfoot><dl id='3Vzuf'><fieldset id='3Vzuf'></fieldset></dl></div>

                              <tbody id='3Vzuf'></tbody>
                            <legend id='3Vzuf'><style id='3Vzuf'><dir id='3Vzuf'><q id='3Vzuf'></q></dir></style></legend>
                            主站蜘蛛池模板: 欧洲亚洲精品久久久久 | 成人综合视频在线 | 欧美成人一区二区三区片免费 | 51ⅴ精品国产91久久久久久 | www.久久99 | 一区中文 | 国产精品美女久久久久久不卡 | 亚洲天堂网站 | 久久久久久免费观看 | 欧美人妖网站 | 日本三级线观看 视频 | 99tv成人影院| 狼色网| 国产一区二区三区在线视频 | 超碰在线免费av | 成人精品一区二区 | 亚洲高清在线 | 国产69精品久久99不卡免费版 | 欧美成人免费电影 | 91精品久久久久久久久久入口 | 成人精品一区二区三区中文字幕 | 欧美精品一二三 | 五月天国产在线 | 免费看国产一级特黄aaaa大片 | 成人精品国产一区二区4080 | 精品伊人 | 精品1区2区 | 97国产精品视频人人做人人爱 | 蜜桃特黄a∨片免费观看 | 国产成人精品久久二区二区 | www.4567| 91精品国产一区二区三区动漫 | 一区二区三区 在线 | 国产资源在线播放 | 国产在线精品一区二区三区 | 蜜桃在线视频 | 亚洲欧美日韩一区二区 | 日本一区二区三区在线观看 | 日韩手机视频 | 久久久精彩视频 | 播放一级毛片 |