Technology, Smartphones, Games

How to change a column to identity–SQL Server

First of all, there is no direct way to do this. You have two options to do this 1. Add all the contents to a new table with Identity column and copy data to that table. Drop the current table and you may rename the table. CREATE TABLE dbo.Tmp_N... [More]

Free Online Training on SQL Server 2008 R2

Free online training on SQL Server 2008 R2 on Virtual Tech Days. Date, Time and Topics 2nd May, 2011 (2:30 pm - 3:45 pm) - Managing and Optimizing Resources for SQL Server 3rd May, 2011 (2:30 pm - 3:45 pm) - Optimizing and Tuning Full Text Se... [More]

Remove Duplicate rows from table - SQL Server

I just came to a situation where I have duplicate entries in a table (all fields are identical) and I want to remove the duplicates. After a search I found a simple solution for my problem. In my case, there were 2 duplicate entries for each record.... [More]