Javascript Back Button

Just like your browser’s back button, the following script allows the user to press a button to returns the user to the previous page. Paste the following code where you want the button to appear on your page:  <FORM> <INPUT TYPE=”Button” VALUE=”Previous Page” onClick=”history.go(-1)”> </FORM> If you would rather use a link, paste the following code where you want the link to appear:  <a href=”javascript:history.back(1)”>Previous Page</a> 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 →