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 entities and relationships?

0 Answers  

---

What is the use of set nocount on/off statement?

0 Answers  

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

Why we should not use triggers?

0 Answers  

---

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

Explain about protocol layer present in SQL server?

0 Answers  

---

What is the need for indexing?

0 Answers  

---

What is policy management?

0 Answers  

---

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

---