Lets say I wanna have a random number between 0 to 2 using MS SQL. How can we do that?

So you need to truncate the log files often to keep the log file smaller in size. The process I am demonstrating here is for MS SQL 2008.

Here is the list of countries coded for use with HTML and ASP .NET. Often times it becomes handy.

Often times its important to see the list of stored procedures in database. So how do you find list of stored procedures in a MS SQL database?

How do you copy the DataRow of one DataTable to another DataTable?

While working on a new project I got into this. I have to have a background on top and also at the bottom of the page. Nothing too difficult. Only problem was making it work on all browsers. On some browsers it seem to show the background color at the bottom instead of re-rendering the bottom to the browser window bottom. So this is what I came up with seem to work on all major browsers.

Many of us have unused domains. I know some people have hundreds of domains sitting doing nothing. They buy them, let them sit doing nothing pointing to a default parked page or redirecting to another existing website we have.