IDENTITY is a property which gives auto-incremental value to a column whenever a new record is inserted. You have to set the IDENTITY property with a column while creating a...

Who said CURSOR is slower than WHILE loops? Didn't you asked them reason...

Hi @Sivaganesh,

First of all explain your problem and the issue you are dealing with?

What all steps you've taken till now and where are you stuck?

Provide some test data and expected...

I was also confused by using and not using WITH with NOCHECK option.

WITH NOCHECK: does not disable FK constraint, but gets disable for existing records.

NOCHECK without WITH: disable the FK...

You can directly query your Excel file by using OPENQUERY() or linkedserver.

Check this link: http://sqlwithmanoj.wordpress.com/2010/11/12/query-excel-file-source-through-linked-server/%5B/url%5D

Check following blog post to get differences b/w IN, NOT IN and EXISTS.

Link: http://sqlwithmanoj.wordpress.com/2011/02/15/not-in-not-exists-joins-with-null-values/%5B/url%5D

Check the following blog post: http://sqlwithmanoj.wordpress.com/2011/05/16/database-schema-diff/%5B/url%5D

Here I've created a script to list out differences in schema of two different databases.

You can add filter WHERE clause for tables, or tweak the...

CTE or Common Table Expressions were introduced in SQL Server 2005. Their main use is to replace the derived queries or sub-queries you apply in your SQL statements. This also...

Check this blog post to identify and delete duplicate records from your tables in various ways: http://sqlwithmanoj.wordpress.com/2011/10/14/identify-delete-duplicate-records-from-a-table/%5B/url%5D

The following blog post will give you differences and performance difference b/w ISNULL() and COALESCE()

Check link: http://sqlwithmanoj.wordpress.com/2010/12/23/isnull-vs-coalesce/%5B/url%5D

I also faced lot of issues while setting up database mail first time. But finally managed to configure it.

So I've put all of those steps at one place, check this...

Till 2007 we used to use MS Visual Source Safe for storing SQL Server objects. It was Ok, just for version control and deploying our builds.

Then we switched to TFS....

Check this blog post[/url] to deal with Duplicate records in a table.

Check my blog post where I've menitioned steps to configure Database Email

Link: http://sqlwithmanoj.com/2010/09/29/database-mail-setup-sql-server-2005/%5B/url%5D

Perform all steps mentioned in the blog post.

Also try out pointing your mail server to GMAIL, check if...

Why don't you create a Stored Procedure and put all your logic that you are executing with EXEC(), and finally call that SP.