Answer / rajkumar

Foreign key consider only the values. According to null value is not a value.

Answer / sureshramsing@gmail.com

Yes foreign key column allows null values, if it is not having either primary key or not null constraints.
Foreign key just reference to the particular parent column only not for restrcting the data while insert or update. It verifies dependency at the time of delete only.

How do I partition a table in sql server?

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,

---

Explain transaction isolation levels in sql server?

0 Answers  

---

What are the character string functions supported by sql server 2005?

0 Answers  

---

How you can change a cross join into an inner join?

0 Answers  

---

What is the difference between delete and truncate statements?

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  

---

How can we solve concurrency problems?

0 Answers  

---

Define msdb database?

0 Answers  

---

What are the new security features added in sql server 2012? : sql server security

0 Answers  

---

Does server sql treat char as a variable-length or fixed-length column?

0 Answers  

---

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

---