If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

---

What are rows and columns?

0 Answers  

---

How to connect PK and FK?

2 Answers  

---

Data table as parameter in sql server?

0 Answers  

---

What is table level trigger?

0 Answers  

---

---

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

What is merge statement?

0 Answers  

---

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,

---

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

What are filegroups in sql server?

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  

---

How to enable tcp/ip protocol on a sql server?

0 Answers  

---