SQL 2005

Here are some scripts to help to you find Duplicate records or records that occur more than once.

SQL Script to find rows which occur more than once.

This SQL should also work with Visual FoxPro

Difference between drop table and delete table in SQL Server

You will notice that there are two ways to get rid of data you don’t require in SQL Server. One is by the Delete Table command and the other one is by the Drop table command. So what is the difference between the two?

Duplicate Rows in a table can be very irritating and cause for many headaches. So how can you identify duplicate rows in a table?  SQL Server provides no visual tool or a built in function to show you the duplicate rows in a table, so you need to write your own query to get the duplicate rows.

If you are working with SQL Server and looking for a way to get the row count of all tables in your database, you can do that using this SQL Query.

This Query will display a list of all Tables in your database and a count of the number of Rows the table has.

If you need to trace all the connections from Applications and other Clients to your SQL Database you can do so with the following queries.

Working with SQL Server can be quite interesting. It’s a quite powerful tool and you can really be creative with what you can do with those SQL Queries.

Error:

System.ArgumentException: The SqlParameter is already contained by another SqlParameterCollection

Error:

Error SQL01268: .Net SqlClient Data Provider: Msg 2627, Level 14, State 1, Line 3 Violation of PRIMARY KEY constraint 'PK_ComponentTypeLu'. Cannot insert duplicate key in object 'dbo.ComponentTypeRef'.

Error:

Step 1:

                Right-Click on the Project in the Solution Explorer and select Properties.

Step 2: