Tablesample

Question

Viewing 3 posts - 46 through 47 (of 47 total)

You must be logged in to reply to this topic. Login to reply

iguillon SSC Rookie Points: 48 More actions · Answer 1

With the drop in the last line, it returns nothing, does it?

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 2

iguillon (9/21/2012)
With the drop in the last line, it returns nothing, does it?

With the DROP coming after the SELECT, I don't see how it could affect what the SELECT returns?

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Paul White SSC Guru Points: 150467 More actions · Answer 3

vk-kirov (9/21/2012)
They had had a sorting but commented it out :ermm:

Thank you for reminding me of that one! :laugh:

Amazing, isn't it.