Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 1 Answers
- 9634 Views
- I also Faced
- E-Mail Answers
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 |
what are batch in sql server?
1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........
Define tool Manage Statistics in SQL Server 2000 query ?
What are different types of subquery?
What is the purpose of the tempdb database?
Explain log shipping and mention its advantages.
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
How to change server name in sql server?
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
How do I find the sql server version?
Difference between sql server 2000 and sql server 2005?
11 Answers Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,
Why people hate cursor?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
