As you know a normal split method is accepting only a character . It will throw an error when we give a string to split. This ...

This code helps you to find out the missing Indexes in SQL [sql] SELECT d.[object_id], s = OBJECT_SCHEMA_NAME(d.[object_id]), o = OBJECT_NAME(d.[object_id]), d.equality_columns, d.inequality_columns, d.included_columns, s.unique_compiles, s.user_seeks, ...

Find the relationship difference between two DB. [sql] SELECT f.name AS ForeignKey FROM sys.foreign_keys AS f where f.name not in (SELECT f.name AS ForeignKey FROM inova.sys.foreign_keys ...

find the relationships between tables in SQL Server 2008 [sql] SELECT f.name AS ForeignKey, SCHEMA_NAME(f.SCHEMA_ID) SchemaName, OBJECT_NAME(f.parent_object_id) AS TableName, COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName, SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName, OBJECT_NAME (f.referenced_object_id) ...

Creating Linked Server: [sql] EXEC sp_addlinkedserver @server=N’IIC82′, @srvproduct=N”, @provider=N’SQLNCLI’, @datasrc=N’IIC82\SQL2008R2′; [/sql] Here you need to replace with your server name.

Find which are all table has set identity. [sql] select COLUMN_NAME, TABLE_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA = ‘dbo’ and COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, ‘IsIdentity’) = 1 order by ...

Hi All, This code will helps you to get the count of entries in each table in a DB in SQL: [sql] SELECT sysobjects.Name , sysindexes.Rows ...

Get the table count in a DB in SQL. [sql] select * from sys.tables where is_ms_shipped=’0′ [/sql]

This will help you to check whether an array element is undefined or not in jquery [js] if (typeof localHeaderColumnArray[0] != ‘undefined’ ) { } else ...

This will help you to parse a string to Json [js] var jsonConvert = $.parseJSON(changedColumnHeaders); [/js] Here changedColumnHeaders is my json string