Answer Posted / arif jameel

ADD a new identity_column (1,1) on <table>
by

alter table <table_name>
add <Identity_column> int identity(1,1)

delete from <table> where <identity_Column> in
(select max(<identity_Column>) from <table>
group by any <table_column_name>)

drop <identity_column>

What are the benefits and tasks of object explorer? : sql server management studio

1256

---

Can primary key be null?

984

---

what are the core components of SSRS?

135

---

How to make conditional sum in ssrs?

183

---

Explain the use of containers in ssis and also their types?

1019

---

What is pessimistic concurrency?

1023

---

What is normalization and its types?

1077

---

Explain filtered indexes benefits?

1042

---

What is create command?

1021

---

Explain “@@rowcount” and “@@error” in sql server?

1132

---

What are the underflow and overflow behaviors on float literals?

1165

---

What is the data tier application?

169

---

How to check if a table is being used in sql server?

1010

---

What command must you use to include the not null constraint after a table has already been created?

1234

---

what is the difference between count(*) and count(1) ?

1125

---