My Sql Note
Source -Web
Pages
(Move to ...)
Home
▼
Monday 5 March 2018
Surrogate Key Implementation Strategies
›
Surrogate Key Implementation Strategies: There are several common options for implementing surrogate keys: Key values assigned by the ...
Lock Types
›
Lock Types: Microsoft SQL Server 2000 has multigranular locking that allows different types of resources to be locked by a transaction. ...
Friday 2 March 2018
Constraints
›
Constraints let you define the way the Database Engine automatically enforces the integrity of a database. Constraints define rules regard...
Friday 23 February 2018
Case Statement
›
Evaluates a list of conditions and returns one of multiple possible result expressions. The CASE expression has two formats: · ...
›
Home
View web version