AddToAny

Share/Save
Home

Sql Server 2008

How Sql Joins Works

Submitted by shantanu on Wed, 07/13/2011 - 02:14
Posted in

To make this article, I have taken Table A and Table B as reference tables for explaining.

SELECT * FROM A
id          name                       RowState
----------- ------------------------------ --------
1           A1                             1
2           A2                             1
3           A3                             0
4           A4                             0
5           A5                             1
 
(5 row(s) affected)
 
SELECT * FROM B
 
id          name                           RowState aid

Delete Duplicate Records From a table

Submitted by sam on Thu, 02/24/2011 - 11:22
Posted in

I need to clean duplicate records from a table, please let me know how to it.

Syndicate content