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 user defined functions in ms sql server?

922

---

Can we insert data into a view?

1061

---

What is a partition function in sql server?

1022

---

Define normalisation?

1060

---

Write a sql query to get zero records from a table having n number of records?

1127

---

what are acid properties? : Sql server database administration

927

---

What are the recovery models in sql server 2000?

925

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

902

---

What do you understand by the data quality services in sql server?

899

---

Do comments need to go in a special place in sql server 2005?

809

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1905

---

What is raid? : SQL Server Architecture

1100

---

Can we store videos inside the sql server table?

907

---

What is cube dimension? : sql server analysis services, ssas

954

---

What is forward - only cursors / read only cursor?

1019

---