Viewing 15 posts - 586 through 600 (of 624 total)
Darn, I jumped wrong there, I guess it is because I just didn't think about it. Not really gone for the concept of DDL triggers much yet so just selected...
November 2, 2011 at 3:42 am
Hugo Kornelis (11/1/2011)
SQL Kiwi (11/1/2011)
Hugo Kornelis (11/1/2011)
Your production code will likely be more careful with these issues.
Can I interpret this as "Your production code will likely completely avoid...
November 1, 2011 at 3:37 am
I am not convinced there is that much gain to be made by taking action which demonstrates lack of trust in staff. Anyone in a dev or DBA position is...
October 28, 2011 at 4:18 am
Wot DugyC sed. Fortunately I overrode my immediate impulse to get this one right!
October 28, 2011 at 4:10 am
Nice one. I got it right - yay! - though I had to spend 20 minutes reading up (sorry work) first, as I was determined to get it right.
I think...
October 27, 2011 at 2:54 am
I am definitely lucky to have a job I enjoy, and one that pays top end of the payscale - and when I start to not enjoy it then I...
October 26, 2011 at 2:23 am
I think there are more complex cases where you need to do the kind of thing discussed in the question - using a subquery - but I did immediately think...
October 24, 2011 at 4:16 am
Probably about 5 on 2000 and a similar number on 2005, a couple set up on 2008, although we have not got many real projects running on 2008 yet, mainly...
October 21, 2011 at 1:10 am
Some of my colleagues have preferred a widescreen - no, I do not get that. Dual anyday, but each to their own.
October 14, 2011 at 4:04 am
@EricGray
I am a general application programmer (admittedly of some experience) and I certainly believe I have the skills to write SQL. Even unsupervised, and without a lot of training. I...
October 11, 2011 at 2:50 am
A very nice question - this is why I continue to do the QOTD. I had honestly never heard of INTERSECT or EXCEPT until today - unbelievable! The precedence totally...
October 11, 2011 at 2:31 am
I'm with IceDread, I don't see this. Our Client Services Manager who is the interface between project team and client will find out what went wrong. In general we do...
October 10, 2011 at 2:50 am
Virender Sihag (10/3/2011)
I have create a view in a database (assume a_db)
now this view fetching records from other database(assume b_db) like (select col1,col2 from b_db..tab1)
Now i have create a...
October 4, 2011 at 3:07 am
Interesting point. My actual line manager actually rarely gives me any direct instruction. I would say our team has no hierarchy of 'command' as such and really does not need...
September 16, 2011 at 2:26 am
Viewing 15 posts - 586 through 600 (of 624 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