Archive for December, 2008

Windows 7 Features, Screenshots, Demo

Windows 7 Taskbar

Windows 7 System Tray


hen you try to restore a database there are some very tricky stuff you need to know.


A list of widely used SQL settings Explained

ANSI NULLS
QUOTED_IDENTIFIER
ARITHMABORT
ANSI_DEFAULTS
ANSI_WARNINGS
DATEFIRST
DATEFORMAT
NOCOUNT
NOEXEC
IDENTITY_INSERT
IMPLICITY_TRANSACTIONS
LANGUAGE

ANSI NULLS
- Syntax
SET ANSI_NULLS {ON | OFF}
- Explanation
The SQL-92 standard requires that an equals (=) or not equal to (<>) comparison against a null value evaluates to FALSE. When SET ANSI_NULLS is ON, a SELECT statement using WHERE column_name = NULL returns zero rows even if there [...]