Delete duplicate rows without using rowid.

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

What is Self Join?

4 Answers  

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 Answers  

What is the difference between views and stored procedures? Can we have input parameters for views?

6 Answers  

How m-m relationships are implemented?

2 Answers  

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,