How to find Duplicate Records In table?
No Answer is Posted For this Question
Be the First to Post Answer
Is mysql better than sql server?
The Difference between 'Count' and 'Count(*)'
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.
What is update_statistics command?
What is the security principal at the database level that represents your session?
What is partitioned view?
What are the advantages of having an index on the sql server?
What is difference between clustered and non clustered index?
how would you improve etl (extract, transform, load) throughput?
How do I view a script in sql server?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is the difference between ddl and dml?