What is the system function to get the current user's user id?

2 Answers   HCL,

---

How to drop an existing table?

0 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,

---

---

How do I shrink an ldf file?

0 Answers  

---

What is named query? : sql server analysis services, ssas

0 Answers  

---

What is the difference between ddl and dml?

0 Answers  

---

How do I create a trace in sql server?

0 Answers  

---

Explain primary key, foreign key and unique key?

0 Answers  

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

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  

---