Search results for sql


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 ...
You are looking for objects such as: tables, views, user-defined functions, and stored procedures; it's even better if they mention additional objects ...
An isolation level determines the degree of isolation of data between concurrent transactions. The default SQL Server isolation level is Read Committe ...
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 ...
Table Constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. SQL Server 2000 support ...
Microsoft® SQL Server™ 2000 Data Transformation Services (DTS) is a set of graphical tools and programmable objects that lets you extract, transfor ...
A livelock is one, where a request for an exclusive lock is repeatedly denied because a series of overlapping shared locks keeps interfering. SQL Serv ...