Tag Archives: Codes

How to identify and delete duplicate records from sql table

March 16, 2009 – 12:12 am

Well I’m sure any SQL developer out there would have encountered a problem where the duplicate records in a table have to eliminated for some reasons. I recently encountered a similar situation where I had to remove the duplicate user name from a table with just one simple query . Here is how I did [...]

By toalakan-web | Posted in MS SQL Server, MS SQL Server 2000, Personal | Also tagged , | Comments (1)

How to get Current DB name and user in MS SQL server?

February 17, 2009 – 12:19 am

Most of the time I forget the command to get the DB name and current user when working. So decided to make post about it no better way to find the info fast. Here are the 2 commands that basically gets the info. Select DB_name() ; Select Current_user; Here is a post that my friend [...]

By toalakan-web | Posted in MS SQL Server | Also tagged | Comments (1)

How to avoid bots from filling up Online forms using Spry?

August 24, 2008 – 11:47 pm

I’m sure every one some day or other were annoyed while filling out the painful CAPTCHA image in the form field. I have hated it all the time and its a pain for the users to read through the image and retype it again. Here is a simple solution that I found out while working [...]

By toalakan-web | Posted in Javascript, Spry | Also tagged , | Comments (1)