Showing posts with label Puzzles. Show all posts
Showing posts with label Puzzles. Show all posts

Thursday, February 25, 2010

Tic Tac Toe TSQL Style

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 .

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))