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

Explain datetime2 data type in sal server 2008?

0 Answers  

---

Can sql server 2016 run on windows 7?

0 Answers  

---

Explain about integration services of Microsoft SQL server?

0 Answers  

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

---

What is save transaction and save point?

0 Answers  

---

What is normalization process?

0 Answers  

---

How many types of Cursor in SQL SERVER?

1 Answers  

---

How to create an multi-statement table-valued function?

0 Answers  

---

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

---

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

---

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

0 Answers  

---

how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,

---