SQL & BI

Blog Post

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),...

2012-06-11

32 reads

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...

2012-04-25

300 reads

Blog Post

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...

2012-04-25

838 reads

Blog Post

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...

2012-04-20

45 reads

Blog Post

CONCAT in SQL 2012

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

2012-04-19

464 reads

Blogs

Daily Coping 12 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

My Toolbox - Greenshot

By

Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...

Daily Coping 11 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQL Standard Confusion

By Phil Factor

Comments posted to this topic are about the item SQL Standard Confusion

SQL Standard Confusion

By Tony Davis

Comments posted to this topic are about the item SQL Standard Confusion

Groupinig using Lists in a report

By Jason

I am trying to create a list type report and can't seem to get...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers