This relationship related question has two potential answers. The first answer (and the one that you want to hear) is the use of foreign key constrain ...
Search results for dba
It's very beneficial for a potential database developer to know the types of triggers available, and how to implement them.
A trigger is a specialize ...
What does NULL mean?
Posted by Devin
The value NULL is a very tricky subject in the database world, so don't be surprised if several applicants trip up on this question.
The value NULL me ...
Any experienced database developer should be able to answer this question with ease. Some of the less-experienced developers will be able to answer it ...
What is Isolation Level?
Posted by Devin
An isolation level determines the degree of isolation of data between concurrent transactions. The default SQL Server isolation level is Read Committe ...
What is Transaction?
Posted by Devin
A transaction is a sequence of operations performed as a single logical unit of work. A logical unit of work must exhibit four properties, called the ...
What are the constraints ?
Posted by Devin
Table Constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. SQL Server 2000 support ...
What is DTS?
Posted by Devin
Microsoft® SQL Server™ 2000 Data Transformation Services (DTS) is a set of graphical tools and programmable objects that lets you extract, transfor ...