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

syntax for deleting the database in T SQL

5 Answers  

---

What is page-level compression?

0 Answers  

---

Is sql server free?

0 Answers  

---

Explain transaction server consistency?

0 Answers  

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

What is transact-sql ddl trigger?

0 Answers  

---

Wht is SQL Injection Attack ?

3 Answers  

---

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

---

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,

---

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

---

what is integrated security (SSPI). why we use in the connection string?

2 Answers  

---