RANKING Function in plain SQL

Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using RANK() function.DECLARE @StudentScore TABLE(StudentName VARCHAR(1),StudentScore INT)INSERT  @StudentScore VALUES ('A',85),...

RANKING Function in plain SQL

Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using...

All about Kerberos authentication

http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx

All about Kerberos authentication

http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx

OFFSET and FETCH Query Options in SQL Server 2012

If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly introduced in SQL Server 2012. You might have...

OFFSET and FETCH Query Options in SQL Server 2012

If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly...

SQL Azure Federation

 What is Federation?

Federation is a database object like other objects such as tables, views, stored procedures or triggers.
It is also known as Sharding.
There can be multiple federations in a database.
It is...

SQL Azure Federation

 What is Federation?
Federation is a database object like other objects such as tables, views, stored procedures or triggers.It is also known as...

CONCAT in SQL 2012

SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to 255 string or variable values in to one single...

CONCAT in SQL 2012

SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to...