What is difference between primary key and foreign key?

0 Answers  

---

How reterive duplicate value in SQL?

6 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's the difference between a primary key and a unique key?

4 Answers  

---

What is sql server used for?

0 Answers  

---

What number aggregate functions are accessible there in sql?

0 Answers  

---

What are different types of raid configurations? : SQL Server Architecture

0 Answers  

---

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---

What is trace flag in sql server?

0 Answers  

---

Explain the working of sql privileges?

0 Answers  

---

Write an sql query for deleting duplicate rows?

0 Answers  

---