Web Resources   >   Database   >   SQL Server XML
October 31, 2014

Reset Identity in SQL Server 2005

DBCC CHECKIDENT(tableNameNoQuotes , RESEED, 0)

Find Duplicates in TSQL or SQL

Here's a handy query for finding duplicates in a table. Suppose you want to find all email addresses in a table that exist more than once:

SELECT email,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )

You could also use this technique to find rows that occur exactly once:

SELECT email
FROM users
GROUP BY email
HAVING ( COUNT(email) = 1 )
Services
Other Services
About Us
Location
Custom Software Applications
Database Programming
Web Development and Design

Search Engine Optimization
Report Writing
IT Consulting
MS Excel Consulting
MS Access Programming
FAQs
Contact
Request a Quote
Free SMS Pro Quote
Alaska Web Design Company
Email: chowell@nwds-ak.com
Phone: 907-227-1676
cash, check, credit card, invoice, paypal
2627 C Street
Anchorage, AK 99503