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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy