Cannot ALTER TABLE in MS SQL 2008/SQL2008 R2/SQL2012

Cannot ALTER TABLE in MS SQL After installing ms sql 2008/2012 you may face new problem which may protect you to alter any table. Something like following There is a new option added in SQL Server 2008/2012 for modifying tables while using the Table Designed in Management Studio which will prevent saving any changes to […]

Calculate Execution and Cpu Time in SQL 2005

SET STATISTICS TIME ON Select * from TableName — Or Any Query SET STATISTICS TIME OFF It Results: =============== SQL Server parse and compile time: CPU time = 31 ms, elapsed time = 141 ms. SQL Server Execution Times: CPU time = 0 ms, elapsed time = 1 ms. (49 row(s) affected) SQL Server Execution […]

Selecting Record from XML Valued Column in MS SQL

Just Consider we have following records in a object named CR_NonDPC_ConfigDTO PCName : PC MotherBoard : ASROK 945 GCM Processor : Pantium HDD : HDD 160 GB RAM : DDR-2 1 GB Cassing : NULL ExtraConfig : CD ROM ASUS Now we shall convert it to XML (for converting Object to XML you can check […]

Executing *.sql file form C#

Sometimes we need to run *.sql script from our application for installing data base. SqlCommand is not right for running installation script because installation script consists of DDL and GO command. Here we use smo library for executing *.sql script. For doing above operation we need to add following references Microsoft.SqlServer.ConnectionInfo Microsoft.SqlServer.Smo Took me a […]

Converting List to DataTable in C#

There is no built in method for converting list to data table in C#. So we can implement following method for converting List to DataTable in C#. public DataTable ToDataTable(IList data) { PropertyDescriptorCollection props = TypeDescriptor.GetProperties(typeof(t)); DataTable table = new DataTable(); for (int i = 0; i < props.Count; i++) { PropertyDescriptor prop = props[i]; […]


Here I shall describe about split in MS SQL. There is no built in function for splitting your text, that’s why I am describing two customize function for performing split operation in MS SQL. Split function 1: This function returns table that’s why we can say it table valued function. –select * from fnSplit(‘1,22,333,444,,5555,666’, ‘,’) […]