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
»
Datetime
(RSS)
sqL Server 2000
SQL Server 2005
Teaser
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
SQL Server 2008 Express with Advanced Services And Tools Now Available For Download
Interesting Bug/Feature In SQL Server 2008 RTM
SQL Server 2008 Management Studio tip: Status Bar Custom Colors
SQL Tip, Compiling Your SQL Without Running It To See If It Would Run
Microsoft SQL Server 2008 Feature Pack, August 2008 Available for download
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
Backup
Benchmarks
Best Practices
Better Developer
Book
Books
Bug
Business Intelligence
C#
Career
dates
Django
Dynamic Management Views
Encryption
Extreme Programming
Functions
Gotcha
Internals
Interview
Katmai
Learning
LINQ
logging
Malware
Microsoft .NET
Microsoft Office
non-technical
NULL
NULLIF
Nulls
OLAP
Opinion
Oracle
Orcas
ORM
OSS
Partitioned Views
Performance
Performance Tuning
pitfalls
podcast
poll
PostgreSQL
Productivity
programmer
programming
Python
query plan
RDMBS
Refactoring
review
Ruby
Ruby on Rails
Sad but true
Scalability
SCHEMABINDING
screencast
Scrum
Security
Services
Shortcut
Snowflake Schema
Solutions
Source Control
Spring
SQL
SQL Controversy
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
SSIS
Teaser
Tip
Tips and Tricks
Tools
transactions
trick
TRUNCATE
T-SQL
Tuning
uniqueidentifier
Upgrading
UPSERT
Version Control
Video
Views
Visual Studio 2005
Visual Studio 2008
Whitepapers
Wiki
Windows Server 2008
XP
Archives
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