Windows 7 video previews

27Dec08

Windows 7 Features, Screenshots, Demo

Windows 7 Taskbar

Windows 7 System Tray

Filed under: news, windows, windows7   |  Leave a Comment

Restore Database MSSMS

04Dec08

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

Filed under: SQL, windows   |  Leave a Comment

T-SQL Settings Explained

02Dec08

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 [...]

Filed under: SQL, tutorials   |  Leave a Comment