Answer / samba shiva reddy . m

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships.
One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships.
Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.

Answer / laxman

using junction table

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 is the difference between inner join and equi join?

0 Answers  

---

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,

---

What is an indexing strategy?

0 Answers  

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

What is data source view or dsv? : sql server analysis services, ssas

0 Answers  

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

Why do you need a sql server?

0 Answers  

---

What is the partitioning method?

0 Answers  

---

How we can refresh the view?

0 Answers  

---

How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  

---