Viewing 15 posts - 1,786 through 1,800 (of 3,348 total)
Good question, mediocre explanation - no errors, but complicating things more than needed.
There are three variations of COUNT:
* COUNT(*) - returns the number of rows, regardless of content.
* COUNT(expression) -...
April 16, 2013 at 7:07 am
Calling a column ID and then putting duplicate values in it is just evil. No raise for the developer who wrote this, and a warning that (s)he'll be fired if...
April 15, 2013 at 1:13 am
PurpleLady (4/12/2013)
Actually deprecated does not mean removed - it means currently supported but will be removed in future versions. So SOAP is a valid type.
No, it is not. SOAP was...
April 12, 2013 at 5:50 am
venkat9.sql (4/9/2013)
I recently corrected an error in a trigger code thats using COUNT(*) = 1 logic to COUNT(*) >= 1 since it overlooks the possibility of multiple rows.
Aarghh! Please change...
April 9, 2013 at 9:31 am
Danny Ocean (4/9/2013)
How it's possible ? Anyone let me...
April 9, 2013 at 4:27 am
The article is a good "how-to" on operating the DTA, but it unfortunately fails to put up a large disclaimer, that the DTA is far from perfect. It is a...
April 9, 2013 at 12:44 am
I'm glad I double and triple checked before replying; I almost fell for it. The glaring error in how the trigger code handles multi-row inserts is so staring people in...
April 9, 2013 at 12:41 am
DavidBridgeTechnology.com (4/8/2013)
Who edits the QOTD submissions and why did they not pick up on this?
Steve has replied to these and similar questions in the past; I don't think anything has...
April 8, 2013 at 3:32 am
nenad-zivkovic (4/8/2013)
I hope someone else can explain why a backslash at the start of the string is considered numeric, as I was surprised at that myself.
I've managed to find this...
April 8, 2013 at 3:27 am
kapil_kk (4/8/2013)
For the first part I understand the behavior but am still confused with the SELECT ISNUMERIC('.+') -- Returns 0 behavior 🙁
The . actually represents 0.0, with leading and trailing...
April 8, 2013 at 1:28 am
An okay question, I guess. The combination of title, question, and answer options may make it very easy to overlook the actual issue, but if we cannot be expected to...
April 8, 2013 at 12:49 am
Jeff Moden (4/7/2013)
April 7, 2013 at 2:06 pm
Jeff Moden (4/7/2013)
david.holley (4/7/2013)
SELECT @NewString = @NewString + NameInitials FROM
(SELECT NameInitials FROM Employees WHERE OfficeId...
April 7, 2013 at 10:07 am
bev.kaufman (4/4/2013)
I think I'm starting to get it. The JOIN clause is about what gets included on...
April 4, 2013 at 1:38 pm
bev.kaufman (4/4/2013)
Okay, then how would you have written a left outer join if you wanted to fetch only the records where the left side had flag = 1?
SELECT ...
April 4, 2013 at 12:41 pm
Viewing 15 posts - 1,786 through 1,800 (of 3,348 total)