I found some pretty cool article By Adam Haines on http://www.sqlservercentral.com
Tic Tac Toe TSQL Style.
Old game in T-SQL style - must read and try .
Showing posts with label Puzzles. Show all posts
Showing posts with label Puzzles. Show all posts
Thursday, February 25, 2010
Monday, August 31, 2009
CAST and CONVERT (Transact-SQL) - Truncating and Rounding Results
Here's some "puzzle" for you dudes .
Before you opening SQL Management Studio and pasting
from clipboard , answer -
what is the result for lines below?
DECLARE @D INT
SET @D = 12345
SELECT CAST(@D AS VARCHAR(2))
Before you opening SQL Management Studio and pasting
from clipboard , answer -
what is the result for lines below?
DECLARE @D INT
SET @D = 12345
SELECT CAST(@D AS VARCHAR(2))
Subscribe to:
Posts (Atom)