Archive
Posts Tagged ‘sql’
SET QUOTED_IDENTIFIER ON/OFF and SET ANSI_NULLS ON/OFF
June 9, 2012
Leave a comment
Most of us use those statements while creating stored procedures and functions. most of us don’t know what is the significance of those statements and how they are useful.
SET QUOTED_IDENTIFIER ON/OFF
Categories: SQL, SQL Azure, SQL Server
#SET ANSI_NULLS ON/OFF, #SET QUOTED_IDENTIFIER ON/OFF, dynamic tsql, sql, sql server, tsql
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
BI Big Data Authors
Sandip Shinde
Manish Kaushik
Suhas Kudekar(MCC)
Umesh M Patil
YashwantOur Visitors
Big Data, Data Analytics and Data Science | BI-BIGDATA.com 