What are the maximum number of Columns in ORDER BY clause in SQL Server?

Posted on : 16-04-2012 | By : Devi Prasad | In : SQL Server Basics

Share:

0


What are the maximum number of Columns in ORDER BY clause in SQL Server?
The maximum number of Columns in ORDER BY clause are Limited only by number of bytes.

Below link gives details regarding maximum bytes per ORDER BY Clause.
What are the maximum Bytes per ORDER BY in SQL Server?

Max Capacity For SQL Server 2012 SQL Server 2008 R2 SQL Server 2008 SQL Server 2005
maximum number of Columns in ORDER BY clause in SQL Server Limited only by number of bytes. Limited only by number of bytes. Limited only by number of bytes. Limited only by number of bytes.

http://msdn.microsoft.com/en-us/library/ms143432.aspx

(Visited 24 times, 1 visits today)



References : Devi Prasad (sqlserverlearner.com)

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.


Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.




Write a comment



Tags: , , , , , , , ,