Tips and Tricks for SQL-BI
Tips and Tricks for SQL Server Developers
SQL Server Questions and Answers
Monday, June 7, 2010
T-SQL Puzzle 3 - Syntax Behaviour
What will be the out of below
SELECT
statements:
SELECT
1.
Columns
SELECT
1.ColumnName
SELECT
(1.)ColumnName
SELECT
'1.'
ColumnName
SELECT
1.#ColumnName
SELECT
$1.ColumnName
SELECT
1.[ a%^& .ColumnName]
Has anyone seen this behavior?
Do you have any idea what's happening?
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Here are few FREE resources you may find helpful.
No comments:
Post a Comment