Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE)
Answer / uma
Yes, it is possible to allow NULL values in a foreign key,
this property has a relation with the another property "ON
UPDATE/DELETE SET NULL".
It is also possible to define multiple constraints on a
single column.
Is This Answer Correct ? | 10 Yes | 4 No |
Which institute is best for SQL Server 2005 Training?
What is the command used to check locks in microsoft sql server?
How are the exceptions handled in sql server programming?
wat new abt truncate in sql server
An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).
Can group by and orderby be used together?
hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju
What is difference between restoration and recovery in SQLServer?
What is the use of placing primary key and foreign key constrains on columns.
What is difference between process and thread? Explain lazy writer funcationality.
Do you know what is sql injection?
What is GUID in sql server?