Thanks you.This will help.

Thanks again.

Avoid sarcasm. Don't insist on the last word.

Thanks for the reply.

This means there is no effect on the queries?

Thanks for the reply.

All I want to know is whether it will affect the query execution time?

Indeed ..an insert operation was on.

Thanks

"c1<---->c2

4<---->2

4<---->3

4<---->4

14<---->12

14<---->13

14<---->14"

How are you deciding when to use 4 and to use 14??

You can use row number () to create ids for all the rows and then based on any column order you can delete 1000 rows:

DELETE FROM

(SELECT...

Partitions would be helpful.Then you could also restrict conditions in where clause

alter table table_name

add sr_no bigint identity(1,1)

Mark as useful if it...

This needed some changes ,but worked fine. Thanks!!

Assuming that earlier loaded data has duplicates which is fine and now I want to upload only unique

data.Any query would help.Thanks!1

Assuming that earlier loaded data has duplicates which is fine and now I want to upload only duplicate data.Any query would help.Thanks!1

Here the collate type that you have chosen is case sensitive and accent sensitive.

The sorting is performed on two levels.

1)b and B will be treated differently.As in your example there...

Alter the precision of the column

ALTER TABLE Testing ALTER COLUMN Testcolumn decimal(16,1)

1)Check datatype of text

2)Remove quotes("")