How to find Duplicate Records In table?


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

Post New Answer

More SQL Server Interview Questions

Is mysql better than sql server?

0 Answers  


The Difference between 'Count' and 'Count(*)'

13 Answers  


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 update_statistics command?

0 Answers  


What is the security principal at the database level that represents your session?

0 Answers  






What is partitioned view?

0 Answers  


What are the advantages of having an index on the sql server?

0 Answers  


What is difference between clustered and non clustered index?

0 Answers  


how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,


How do I view a script in sql server?

0 Answers  


Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,


What is the difference between ddl and dml?

0 Answers  


Categories