Techie Talks
Monday 7 May 2012
Remove duplicate records from a table
If in an old table in sql server 2005,by mistake you have duplicate records you can create a new table with distinct records using:
select
distinct
*
into
New Table
from
Old Table
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment