Skip to content
Advertisements

How to get Query String from URL in Javascript

function getQueryStringFromURL(key) { var queryString = window.location.search; var subQrString = queryString.substring(1); var arrQueryString = new Array(); var arr = subQrString.split(‘&’); var index = -1; for (var i=0;i<arr.length;i++) { index = arr[i].indexOf(‘=’); if (key == arr[i].substring(0, index).toUpperCase()) { return arr[i].substring(index + 1); } } return null; } Advertisements

Read More →

SQL Query to get modified procedures

SQL Query You can use a simple query in sql server 2005 to get the modified procedures from a particular date. You just need to specify the date in the query. Try it out !!! SELECT name , modify_date FROM sys.objects WHERE type = ‘P’ AND modify_date >= ‘2011-11-24’ order by name In the same way, you can retreive the modified tables also SELECT name , modify_date FROM sys.objects WHERE type = ‘U’ AND modify_date >= ‘2011-11-24’ order by name

Read More →