Now we got the point I think.

Sorry for the error on choice d). I did test for each choices. Not sure how it happen. Could Steve Jones please change it from "delete table...

Thank you for your input. I am agree with you. but... can we refer to this link?

http://use-the-index-luke.com/sql/partial-results/top-n-queries

I think "Order By" just do for "Top (n)" rows...

The results is right. But for logical query processing, I think efficient way for SQL Compiler is do Top first then Order by. For a large table, do...

Order BY is last, Top should before it.

if refer to this link:

http://www.sql.co.il/books/insidetsql2008/Logical%20Query%20Processing%20Poster.pdf

all answers is not right

drop and re-create the object with its new name, will change the object permission. it need very careful for production server.

Different ways to Backup your Windows Azure SQL Database

:hehe:

Thanks for the great question!

If you want retunr 5? here you go,

select COUNT(@@ERROR) FROM #temp

select COUNT(0) from #temp

select COUNT(100000000000000000000000000000) from #temp

select COUNT('ZZZZZZZZZZZZZZZZZZZZZZZZZZZZ') from #temp

select COUNT(-5.0) from #temp

select COUNT(+5.0) from #temp

select...

from the link:http://msdn.microsoft.com/en-us/library/ms162560.aspx

Implementing Endpoints

SQL Server 2012 Other Versions SQL Server 2008 R2SQL Server 2008SQL Server 2005This topic has not yet been rated - Rate this topic An endpoint...

For better understand about the topic, we may need know the "Logical Query Processing" by Itzik Ben-Gan.

http://www.sql.co.il/books/insidetsql2008/Logical%20Query%20Processing%20Poster.pdf

I found this option in SQL 2020 SP4

Thank you for the posting.

We have many different ways to approach it. Is it a good idea or a bad idea?

BOL - Restrictions

You cannot use TRUNCATE TABLE on tables that:

•Are referenced by a FOREIGN KEY constraint. (You can truncate a table that has a foreign key that references itself.)

Do...

Nice question, make us thinking.