Tomaz.tsql

Browse by Tags

All Tags » datefirst (RSS)
WITH CTE calculating difference in days
Wanted to calculate number of days on vacation? or you want to break it down by months? Solution for 2005/2008 using WITH CTE: create table TBL_Vacation ( Name varchar ( 10 ) , DateFrom smalldatetime , DateTo smalldatetime ) insert into TBL_Vacation select...
Posted: Sep 20 2010, 11:49 AM by Tomaz.tsql | with no comments
Filed under: , ,
DBCC USEROPTIONS
this is something every DBA should know by heart. I mean, everyone. running query: [DBCC USEROPTIONS] Returns following options each DBA can set on current database that will be affected globaly: 1. textsize 2. language 3. dateformat 4. datefirst 5. lock_timeout...