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 ...

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 ...

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’ ) { ...

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] ...

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 ...

Find a number from a string and remove in JQuery [js] var str="Sibeesh007" str.replace(str.match(/(\d+)/g)[0], ”).trim(); [/js] Here str is my string. I hope it ...

Get the row count of JQX Grid JQwidget. [js] var dataCount = $(‘#jqxgrid’).jqxGrid(‘getrows’); var len=dataCount.length; [/js] I hope someone finds it is useful.

[js] var num=’$100%’; $(‘div’).text(num.replace(/\,/g, ”).replace(/\$/g, ”).replace(/\%/g, ”)); [/js] Kindest Regards Sibeesh Venu