Archive

Archive for June 6, 2012

Get a comma separated list in SQL & MDX.

To get a comma separated list in SQL as well as in MDX use below queries.

Sequence Vs Identity – SQL Server 2012

June 6, 2012 6 comments

What is sequence?

Sequence is a newly introduced database object in Sql Server 2012, Sequence is used to generate a sequence of numeric values in either ascending or descending order, along with an option to have the minimum and maximum values and also allows to cycle and cache for better performance.

Read more…

%d bloggers like this: