Answer / koteshwar rao .palleboina

when foreign key constraint is created on a column
referential integrity is achieved .
when foreign key constraint is created on a column,that
column reference other column in the different table or
even in the same table but the reference column must be
primary key or unique key.
when a new value is added in a column referenced with
foreign key ,then the foreign key relation checks whether
the new value matches with the reference column or not.
If value matches then they are allowed into the table

What are unicode character string data types in ms sql server?

0 Answers  

---

How to find the source of a table in sql server?

0 Answers  

---

What is transaction server distributed transaction?

0 Answers  

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

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  

---

What are the types of constraints?

1 Answers  

---

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

0 Answers  

---

How you can change the database name in SQL SERVER?

0 Answers  

---

What is a join and their types?

2 Answers   Challenger Financial,

---

How to use copy and concatenate commands in SQL?

0 Answers   Amdocs,

---

How do you send email on SQL Server?

0 Answers   MindCracker,

---

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

---