Viewing 15 posts - 1 through 15 (of 26 total)
sisiralek (10/24/2011)
CREATE TABLE [tempdb].[dbo].[sysutility_batch_time_internal] (
...
July 2, 2015 at 3:25 am
andrew.mckee (6/17/2013)
SELECT 'CREATE VIEW ' + TABLE_SCHEMA + '.vw_' + TABLE_NAME + ' AS...
October 27, 2014 at 10:39 am
I replied to this QOTD quite early on but I have revisited it a few times due to the comment emails I get from it.
Never before have I seen so...
April 8, 2013 at 2:13 am
I am sorry to have to say that I did not like the wording of the question or the answers and I am surprised at myself for answering this question...
April 4, 2013 at 2:24 am
Mike McIver
"David looses 90% for the snipe at Microsoft ... long live Bill Gates! David needs to attend the Redmond Reeducation Camp.
"
Long Live Bill Gates? - Tee hee!
I love Microsoft...
April 4, 2013 at 1:56 am
I think the title is misleading and a little unfair to the wonderful work Microsoft did with Merge (Despite its being 6 years after Oracle - poor show MS).
This is...
April 3, 2013 at 2:23 am
Wow Tom. Epic yet fantastic explanation of the inner working off this qotd.
Thanks very much for that. I thought it was interesting when I posted it but you really took...
March 14, 2013 at 6:09 pm
I haven't tried this but i got it wrong (apparently). I don't think the proposers answer is correct though as SQL will terminate after 32 levels of nesting which...
March 2, 2013 at 12:27 pm
-- In 2008 + you can use a date instead of a datetime with implicit conversion
DECLARE @Date date = GETDATE()
SELECT DATEADD(DAY, -DATEPART(dayofyear,@Date),@Date)
January 9, 2013 at 9:34 am
Toreador (1/9/2013)
DavidBridgeTechnology.com (1/9/2013)
When is New Years Eve anyway?February 9th 😉
Ha Ha.:-P
January 9, 2013 at 9:26 am
Whilst others are being picky I thought I would add my bit.
None of the answers are right
When is New Years Eve anyway?
If its January 9th (as it is today) then...
January 9, 2013 at 7:38 am
In case anybody wonders, on a similar note...
Can table valued parameters be used in a function?.
.
.
.
Yes!
and they are very useful fo creating functions that take name-value-pairs
e.g.
CREATE TYPE [dbo].[AuditNVP] AS TABLE(
[Name]...
December 18, 2012 at 2:55 am
I love indexed views
Actually I hate indexed views
Actually I love indexed views
Actually I hate indexed views
Actually I love indexed views
Actually I hate indexed views
Actually I love indexed views
Actually I hate...
December 17, 2012 at 5:28 am
Select #2 Returns 2 rows ???
I don´t think so..
Error converting string value '2013DEC32 00:00:00' into data type datetime using culture ''.
Yep - I thought that too but also do...
December 17, 2012 at 4:57 am
it would probably make sense for BOL to have a NULL Handling section for every functions help page
Great idea!
Dave
December 12, 2012 at 7:28 am
Viewing 15 posts - 1 through 15 (of 26 total)