Viewing 15 posts - 31 through 45 (of 96 total)
I agree with Jeff, it is a good primer on boolean logic. From the title I thought the article would be about the bit data type though, so I...
April 9, 2012 at 11:42 am
Nice job, Jeff!
I thought for sure an "old school" approach uing an inner join and a left join exclusion would be faster, but it got blown away in 10M row...
March 29, 2012 at 9:12 am
@ HEB1014 and christian.stahl
The author's example query is different than the query you're discussing.
The author is suggesting:
IF EXISTS(SELECT * FROM dbo.Book) print 'Records found'
There is no count(*) in the author's...
August 30, 2011 at 11:25 am
majorbloodnock (8/8/2011) ... No-one with any taste buds would take a perfectly acceptable alcoholic drink and cool it so much that it freezes...
A perfectly acceptable alcoholic drink? Have you...
August 8, 2011 at 3:06 pm
Ben,
Sounds like you might be doing a "Script table as"->"CREATE To"... Which, of course, gives you column defs and more.
You can also do a "Script table as"->"INSERT To"... ...
June 15, 2011 at 11:36 am
@ GSquared: Thanks for keeping the cookies in your example!
"The trailing vs leading commas thing is specious. There is NO actual advantage to either one."
I agree the discussion is...
June 15, 2011 at 9:00 am
AndyOwl (6/14/2011)
Consider the following shopping list:
, cheese
, milk
, bread
I agree it's sensible and scientific, but I sitll...
June 14, 2011 at 3:37 pm
AaronTC05 (6/14/2011)
RE: Common SQL Error 3 - You're Using the Wrong DatabaseThe way I get around this is to fully qualify all my table names with dbname.schema/owner.tablename
...
Many organizations have multiple...
June 14, 2011 at 9:18 am
I did not find this to be a good introductory article on DISTINCT. I gave this article 1 star and I have "the nads to say why".
I often see SELECT...
February 8, 2011 at 11:07 am
jeetv (7/7/2010)
I tried using this nice code in SQL Server 2005 but it fails with the message "Only functions and extended stored procedures can be executed from within a...
October 27, 2010 at 4:55 pm
Whoa! RBarryYoung, I did not mean to call you or anybody else a troll. I respect your work and posts here at SSC. My point was that...
February 18, 2010 at 11:06 am
RBarryYoung (2/18/2010)
...Cursors are much, much more undesirable than Dynamic SQL, and should be avoided at all costs.
All costs? Sounds like trolling, to me. I know my boss would...
February 18, 2010 at 10:19 am
I agree with Kevin's comments regarding avoidance of dynamic SQL. But, even if those issues were not a problem, I would still just leave the original cursor loop alone....
February 18, 2010 at 9:26 am
Excellent job! Well written article. I was worried when I read the article's description in the e-mail summary: "Do your system contain a time bomb in the code?"...
February 10, 2010 at 8:58 am
I recommend reading prior posts to get some background how this thread has been progressing. I noticed the solution you posted is a direct quote from the first post...
October 16, 2009 at 2:18 pm
Viewing 15 posts - 31 through 45 (of 96 total)