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 2000
(RSS)
Datetime
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
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
Best Practices
Better Developer
Book
Books
Bug
Career
cloud computing
dates
Django
Dynamic Management Views
Encryption
Extreme Programming
Functions
Gotcha
Hacks
Hardware
HotFix
Identity Theft
In the cloud computing
Index
Indexing
Internals
Interview
Katmai
LINQ
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
SQL
SQL Controversy
SQL Data Services
SQL Injection
SQL Server
sqL Server 2000
SQL Server 2005
SQL Server 2008
SQL Server Data Services
SQL Server Integration 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
WCF
Webcast
Whitepapers
Wiki
Windows Server 2008
Windows Server 2008 R2
XP
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