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

28 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

210 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

33 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

Introducing ScriptDOM

By

I’ve been meaning to get a series of blog posts started on this topic....

Daily Coping 21 Jan 2021

By

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

Using dbachecks for CIS Security Checks

By

Well back at the end of 2019 I finished writing most of the checks...

Read the latest Blogs

Forums

Process to solve Quickbooks error code h202

By daniel2424

Quickbooks is accounting software used in many companies to manage their daily data. Sometimes...

How to delete records selected from another table in stored procedure

By John_Kennedy

CREATE PROCEDURE usp_DeleteEmployeeRcord ( @days Int ) AS BEGIN DELETE [dbo].[EmpMainTable] Where created <...

Multiple dates

By rafamaniac

I am new to data warehouse schema and i learning about role-playing dimensions. i...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers