How to insert data into an existing table?

0 Answers  

---

Explain what role entity and relationship play in an ER diagram.

0 Answers  

---

What are the source of constraints?

0 Answers  

---

what is normalization? Explain different levels of normalization? : Sql server database administration

0 Answers  

---

How to write a query with a right outer join in ms sql server?

0 Answers  

---

Explain different isolation levels?

4 Answers  

---

do views contain data ?

0 Answers   MCN Solutions,

---

how many type of indexing in database?

0 Answers   IBM,

---

What is an index?

8 Answers   Yardi Software,

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

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  

---

Where is trigger in sql server?

0 Answers  

---