[h3]Horror story[/h3]

I have finally found a way to have my aggregates back to work. I had some broken web pages using them also on the public web site, so I...

Derek Dongray (5/15/2008)

---

davidthegray (5/15/2008)

---

I wonder why, although I chose the correct answer (I doublechecked with the back button), it says "You are wrong". And the precentages show total much more...

I wonder why, although I chose the correct answer (I doublechecked with the back button), it says "You are wrong". And the precentages show total much more than 100%. There...

I personally like the idea of bringing managed code inside SQL Server. Sometimes saving a few milliseconds is not the most important thing: having cleaner and more manageable code than...

For the sake of precision, I think the correct answer should have been formulated as

Query will succeed if the customerid and pricingplan columns are available in any table used...

Today I have opened my VS2005 old project in my old machine, which still has VS2005 installed. I deployed the old project to the server but nothing has changed. Still,...

I'd like to understand how security is implemented for CLR custom aggregates.

The EXECUTE permission can be easily given on the CLR custom scalar value functions (among others), but I'm not...

Yeah, sure, I forgot the ON part of the join... 😛

I'll give this code a try tomorrow. I still don't like it. I'll probably put an IF @rowcount > 1...

Matt,

Then you should start firing your lighter.

See this sample:

CREATE TRIGGER ToyInventory_UPDATE ON ToyInventory AFTER UPDATE

AS

DECLARE @rcnt int

SET @rcnt=@@ROWCOUNT

IF @rcnt=0 RETURN

IF @rcnt > 1 BEGIN

RAISERROR('You may only change one...

Hi Steve. Thanks, but this does not really answer my question.

Triggers are supposed to run just once if a single SQL instruction updates several rows in one time. Let's pretend...

Hi. I'm trying to understand what happens using the COLUMNS_UPDATED() or UPDATE() functions in a trigger when a multirow update is in process.

Do those functions do the check on the...