Web Resources   >   Database   >   SQL Server XML
October 10, 2015

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 )
Other Services
About Us
Custom Software Applications
Database Programming
Web Development and Design
Search Engine Optimization
Report Writing
IT Consulting
MS Excel Consulting
MS Access Programming
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