SQL Server ORDER BY when using Dynamic SQL

zc0qhyus 于 2023-11-16 发布在其他

关注(0)|答案(1)|浏览(128)

I keep encountering a syntax error when trying to ORDER BY on a section of dynamic SQL.

I have fairly basic knowledge of SQL but here's what I've tried (I don't want to include entire code), I have correctly declared SQL and DBName at the top, as well as using EXEC at the bottom:

SET @SQL = N'SELECT TOP 1
Test_Time,
Test_ID,
FROM ' + QUOTENAME(@DBName) + '.dbo.Event_Table'
ORDER BY Test_Time DESC

I would just like to know if this is possible or whether I need to try another method. The issue is in ORDER BY as code works perfectly without it.

sql-server

来源：https://stackoverflow.com/questions/77488393/order-by-when-using-dynamic-sql

1条答案

按热度按时间

llycmphe1#

The ORDER BY has to be within the @SQL text string like so:

SET @SQL = N'SELECT TOP 1
Test_Time,
Test_ID,
FROM ' + QUOTENAME(@DBName) + '.dbo.Event_Table
ORDER BY Test_Time DESC'

(I just moved the trailing apostrophe (') from after Event_Table down one line to after DESC .)

赞(0）回复(0）举报 2023-11-16

我来回答

SQL Server ORDER BY when using Dynamic SQL

1条答案

相关问题

热门标签

最新问答