Formatting DateTime to Date in SQL SERVER
Select convert(varchar(10),GetDate(),101) Output: 04/16/2009 Select convert(varchar(10),GetDate(),103) Output: 16/04/2009
Year: 2013
Finding duplicates with SQL?
Suppose Col1 is the field name for which you want to find duplicates: Select Col1, Count(Col1) as count from table1...
Stop Youtube from displaying related videos
To stop displaying related videos we can add a parameter (rel=0 for stop displaying) to the url of the embedded...
Difference between Stored Procedures and Views
Here are some of the differences between stored procedures and views Stored Procedures Can accept parameters Can contain multiple statements...
How Can I Use Javascript to Allow Only Numbers?
function isNumberKey(evt) { var charCode = (evt.which) ? evt.which : event.keyCode if (charCode > 31 && (charCode < 48 ||...
301 Redirect in classic ASP
<% Response.Status = "301 Moved Permanently" Response.AddHeader "Location", "http://www.website.com/" Response.End %> Above code is enough for Redirection but its better...
Permanent (301) redirection in PHP
Following is the code for permanent (301) redirect using php. A better approach would be to use .htaccess but there...
Check a website in Google Cache
Use following URL. Replace mywebsite.com with the website url to check without http
Check your website for malware
Check your website for malware using Google Safe Browsing Tool http://www.google.com/safebrowsing/diagnostic?site=yourwebsite.com
Delete all rows of a table in JQuery except first row
$(document).ready(function() { $("#myTable").find("tr:gt(0)").remove(); });
