What is an index in a database?

0 Answers  

---

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

---

What is the difference between dropping a database and taking a database offline?

0 Answers  

---

what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  

---

Is mysql the same as sql server?

0 Answers  

---

---

What are the different authentication modes in sql server?

0 Answers  

---

How do use Having,Group by,Group function in SQL?

0 Answers  

---

Is INSTEAD OF trigger directly applicable to Table ?

0 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  

---

Explain the first normal form(1nf)?

0 Answers  

---

What is the difference function and stored procedure?

0 Answers  

---

What is the recursive stored procedure in sql server?

0 Answers  

---