THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Sign in
|
Join
|
Help
in
Denis Gobo
(Entire Site)
Search
Home
Blogs
Forums
Roller
Downloads
Opml
Denis Gobo
Browse by Tags
All Tags
»
dates
»
SQL Server 2005
»
Teaser
(RSS)
Datetime
sqL Server 2000
SQL Teaser: Guess the output
What do you think will be the output? DECLARE @d datetime SET @d = '20071010' SELECT DATEADD (yy, DATEDIFF (yy, 0, @d)+1, -1) Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
Read More...
Posted
Wednesday, October 10, 2007 11:46 AM
by
Denis Gobo
|
6 Comments
Filed under:
Teaser
,
sqL Server 2000
,
SQL Server 2005
,
dates
,
Datetime
This Blog
Home
Email
Links
Syndication
RSS 2.0
Atom 1.0
Recent Posts
Cumulative update package 2 for SQL Server 2008 has been released
Microsoft SQL Data Services public CTP announced
Some of my reasons for upgrading to SQL Server 2008
Windows Server 2008 R2 Will Support 256 Logical Processors And Will Be 64 Bit Only
Interview With Denny Cherry About SQL Server
links
SQL Server Code,Tips and Tricks, Performance Tuning
SQL Server BOL
The Curse and Blessings of Dynamic SQL
5 Books Every Developer Should Read
Less Than Dot
Good SQL Articles To Read If You Can't Afford Books
SQL Server Programming Hacks
People I Interviewed
Louis Davidson
Itzik Ben-Gan
Ken Henderson
Adam Machanic
SQL Books I Recommend
Inside Microsoft SQL Server 2005: T-SQL Querying
Pro SQL Server 2005 Database Design and Optimization
The Guru's Guide to Transact-SQL
The Guru's Guide to SQL Server Architecture and Internals
Inside Microsoft SQL Server 2005: The Storage Engine
Expert SQL Server 2005 Development
Tags
.Net 3.5
Agile
Azure
Backup
Benchmarks
Best Practices
Better Developer
Book
Books
Bug
Business Intelligence
C#
Career
CASE
Celko
cloud computing
COALESCE
code
dates
Datetime
DELETE
developer
Dimensional Modeling
Django
DLINQ
dmv
Dynamic Management Views
Encryption
Excel 2007
Extreme Programming
Feature
Federated Databases
Forum
Functions
geeky
General
Gotcha
Identity Theft
In the cloud computing
Index
Indexing
Internals
Interview
Job
Joe Celko
Katmai
Kilimanjaro
Learning
LINQ
logging
Malware
meme
Microsoft
Microsoft .NET
Microsoft Office
Multicore
NULL
OLAP
ORM
Performance
podcast
PostgreSQL
programming
Python
Refactoring
Sad but true
Scrum
Security
Spring
SQL
SQL Controversy
SQL Data Services
SQL Injection
SQL Myth
SQL Server
sqL Server 2000
SQL Server 2005
SQL Server 2005 Analysis Services
SQL Server 2008
SQL Server 2008 Express
SQL Server Data Services
SQL Server Data Services Architecture
SSAS
SSDS
SSIS
Star Schema
Subversion
Teaser
test
time
Tip
Tips and Tricks
Tools
Tortoise
Trace
trick
TRUNCATE
T-SQL
Video
Visual Studio 2008
Archives
November 2008 (4)
October 2008 (4)
September 2008 (1)
August 2008 (6)
July 2008 (6)
June 2008 (6)
May 2008 (16)
April 2008 (10)
March 2008 (5)
February 2008 (12)
January 2008 (9)
December 2007 (16)
November 2007 (13)
October 2007 (7)
September 2007 (6)
August 2007 (8)
July 2007 (17)
June 2007 (14)
May 2007 (3)
©2006-2008 SQLblog.com
TM
Brought to you by
Peter DeBetta
& Adam Machanic
Privacy Statement