My Sql Note

Surrogate Key Implementation Strategies: There are several common options for implementing surrogate keys: Key values assigned by the ...

Lock Types: Microsoft SQL Server 2000 has multigranular locking that allows different types of resources to be locked by a transaction. ...

Constraints let you define the way the Database Engine automatically enforces the integrity of a database. Constraints define rules regard...

Evaluates a list of conditions and returns one of multiple possible result expressions. The CASE expression has two formats: ·    ...