SQL Server Code,Tips and Tricks, Performance Tuning
A blog about SQL Server, Books, Movies and life in general
Showing posts with label
Dates
.
Show all posts
Showing posts with label
Dates
.
Show all posts
Saturday, February 13, 2016
Quickly change m/d/yyyy dates to mm/dd/yyyy dates in Excel
›
Sometimes you get data in an Excel or csv file and it will be in a m/d/yyyy format. Here is an example 1/1/2005 2/1/2012 2/12/2012 1...
Sunday, August 17, 2008
Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code
›
Take a look at this query. SELECT * FROM ( SELECT customer_id, ‘MTD’ AS record_type, COUNT ( * ) , SUM ( … ) , AVG ( … ) FROM payment_t...
Thursday, January 10, 2008
Yet Another Date Teaser
›
It has been a while since my last teaser but here we go What do you think the following returns? SELECT CONVERT ( datetime , '1/1/1...
Wednesday, October 10, 2007
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) Aft...
2 comments:
Tuesday, August 21, 2007
SQL Server 2008 Live Meeting Event on August 21st on DateTime function
›
Don't forget, today is the day of the SQL Server 2008 Live Meeting Event. Here is what I got in my inbox: We wanted to remind you that o...
Wednesday, August 01, 2007
SQL Server 2008 Has Nanosecond Precision?
›
It looks like SQL Server 2008 has nanosecond + microseconds precision for the time datatype If you run the following [edit]I just looked at ...
›
Home
View web version
