Archive
Archive for June 6, 2012
Get a comma separated list in SQL & MDX.
June 6, 2012
Leave a comment
To get a comma separated list in SQL as well as in MDX use below queries.
Categories: Business Intelligence
comma seprated, MDX, sql, ssas
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.
Categories: Business Intelligence, Denali, SQL Server
identity, sequence, sql server