What do you mean "change Identity of a column of a table"?

What exactly you are trying to do?

Change the column type to IDENTITY.

If you're going to make all calculations by yourself then keep information about different products in different tables, as it's suitable for you, human being.

If you wanna make SQL Server...

So what's a problem?

DIFFERENCE = 4 means "the least possible difference", see BOL.

So, it returns you proper warning that those 2 strings are very similar as they actually are.

And what if you'll succeed in this?

Would you consider that numbers '1644700809' and '1644708009' are actually the same?

It's really dangerous. Don't even think about it.

Vendor could have ProductionCategory included into...

If vendor could fix one error then they could fix and another one.

But if you have city stored in separate column your task becomes really easy:

Update    table

Set location =...

If you intend to create separate table for each contact record they send to you???

If you really believe it's a great idea you can use

SELECT @Company Company, @Name...

Anita,

your application is not fixed!!!

As I can see user enters parts of address into separate fields, and application concatenates it into one string before saving it in database.

STOP IT!

Fix the...

Do you want to send select statement or resultset it returns?

Create table "OrderDetails", populate it with right data and then query it.

Actually your example does not have any relation neither to TSQL nor to relational databases at all.

First of all - the task is really stupid.

Why anybody would need 2 columns with exactly the same data?

If you mean to make some modifications to the data later you...

SELECT A.ID_TOWN,

CASE @field WHEN 'Col01' then A.Col01 WHEN 'Col02' then A.Col02 WHEN ... END,

CASE @field WHEN 'Col01' then B.Col01 WHEN 'Col02' then B.Col02 WHEN ... END, 

Anyway it's good to learn some basics about syntax of the language before you try to use it.

Detach database, move files to a new location and attach it again.

Are you sure this E: drive is local, not mapped network drive?