Viewing 7 posts - 1 through 7 (of 7 total)
I agree with Zidar, an uncomplicated explanation of superkeys. Of course there are always other ways to do things and complications to add on (ask a watchmaker) but, if the...
August 7, 2017 at 4:29 am
I know this is a while ago but just in case anyone is looking......
A technique I use is to look in the job history. The history record is only...
September 4, 2012 at 5:08 am
I'm worried by your comment "not so common collation Latin1_general_ci_ai". Whilst new to SQL some years ago I installed a third party system that recommended this collation. I...
August 18, 2012 at 12:54 am
What could be better you ask. How about doing it all in the database and leaving out he SSIS stuff. I had an occasion in the old 2000...
November 8, 2011 at 6:32 am
Thanks for that, now I understand - its a well documented, intentional lousy design whereas a bug is an undocumented, unintentional lousy design. By the way, BETWEEN is also...
September 29, 2011 at 2:54 am
I too thought the question was fine - its the answer I have a problem with.
Hands up all those who think this is a bug
September 28, 2011 at 11:44 am
The trick is from SQL - not the author. Between two dates ought to work whchever way round the dates are presented. Could this be described as a...
September 28, 2011 at 7:08 am
Viewing 7 posts - 1 through 7 (of 7 total)