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

This will solve you to delete an element from an array in JQuery using the index Consider following is my array [js] localHeaderColumnArray: Array[2] 0: "f" ...

Round Off the number to two decimal places in JQuery. [js] var num=2.48776582879546876542576876875325438965235; alert( num.toFixed(2)); [/js] Here toFixed is the function which does the operation. You ...