Global warming is a problem. It comes due to:

- some events on the sun

- high emission of greenhouse gases, one of them is CO2, but there are many other like...

Oil companies forsake all alternatives, as they cut profits. Care for profits is above everything. I don't mean just alternatives for fuel (ethanol, hydrogen from plants) and energy (wind, solar,...

I, as dba, developer and designer, reject requests that would compromise usability, integrity, security or would unnecessarily complicate GUI, data model or both.

The most recent was like this: two fields...

Jack, to my dismay, you're absolutely right. Raiserror in this form is just a message and execution continues normally.

I uncommented Select 'test' and added return 1 after raiserror and both...

Jack Corbett (10/14/2008)

---

Robert,

Thanks for the comment. I believe you are incorrect in stating that the transaction will not fail on an error with the trigger. An error in...

UNION ALL simply concats the results, UNION removes the duplicates, the best way to do it is to sort the result, so NULLs come first.

Try this:

SELECT 3 UNION SELECT...

Good article. I have a small correction. If the after trigger fails (or raises an exception), it does not fail the transaction. The client must handle it.

A well behaved client...

Luke L (9/23/2008)

---

The OP specified this in the WHERE statement

sales_in_no >= 199901 AND sales_in_no <= 199701

Reordered that becomes

EDIT: modified due to GT LT tags getting stripped out.sales_in_no <= 199701...

You mean this?

This query returns no data. I suggested using between as it's more obvious that bounds...

GilaMonster (9/22/2008)

---

That's if bookmark lookups are required, and often the tipping point is closer to 1%. If the index is covering then SQL will normally use the NC index, even...

psangeetha (9/19/2008)

---

Sorry, that was a typo.

This is the output I get from the execution...

It's like the question: What is the color of apples?

a) some are red, some are green

b) some are red, some are yellow

c) partly red, partly green

d) brown

Which answer is 100%...

Ups, right. My apologies.

Nice trick....

"A coworker prank where the error text was directly typed into the Result Messages tab"

What? Can't do.

you can write some text there, but not in red. The "correct" explicitly says...

SQL injection attack can do anything. If it inserted blanks to columns, well, it looks too harmless. However, removing all blanks from all text columns would most probably do even...