Running a 32-bit application on 64-bit Windows Server
1. Change build configuration platform to x86 in Visual Studio. Its set to AnyCPU by default 2. Set the application's...
Month: February 2013
Disallow folders using Robots.txt
User-agent: * Disallow: /folder1/ Disallow: /folder2/ Where folder1 & folder2 are the folders which should be hidden from the search...
Custom 404 Error Page
Set 404 page using .htaccess ErrorDocument 404 /404-error-page.html Change Where 404-error-page.html to your error page
Rounding a number to 2 decimal places in SQL SERVER
Use T-SQL Convert Function. Select convert ( decimal(8,2) , 9.4125 ) Output: 9.41
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
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...
