I prefer multiple triggers. But, it's easier to fall in recursive triggers.

To get values from other tables or columns of the same table but different row, you should use a function:

CREATE TABLE [dbo].[a2]

(

[a1ID] [int] NULL,

[col3] AS (a1ID^2)

)

GO

create function get_a2_col3(@a1id int)

returns int

as

begin

...

Please, do not start a discussion about NULLs. 😀

Hugo Kornelis (11/9/2010)

---

Nice, easy question.

I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually...

I agree! :-D:-D:-D

I disagree with explanation, it's enough to convert to INT

Select...

Hello, terrance

May you explain this syntax?

I think it is very dangerous to transfer search condition in the WHERE clause,

because you can alter result of "LEFT JOIN" that becomes a pure...

I think the question author CONFUSED himself with the syntax for compound operators, as you...

So it seems that the explanation of the question is wrong, as it states that the pre-increment operator is not used in SQL Server. SQL Server uses however a compound...

-- non standard ansi

SELECT NullableColumn FROM NullOperation WHERE ISNULL(NullableColumn,'') <> '1'

OR

-- standard ansi

SELECT NullableColumn FROM NullOperation WHERE COALESCE(NullableColumn,'') <> '1'

Hugo Kornelis (10/22/2010)

---

I got it wrong. I blame my total lack of interest in the R2 release.

But a quick question - if Multi-Server Administration was a new feature in SQL...

Thanks Hugo.

I work with SSMS sql2500, too.

I answered TRUE, but reading and re-reading both question and answer, I do not understand why it's false. Please Hugo, help us to understand.

Be aware of computed columns that use complex formula or call functions, they may lead to performance problems:

create function getsum(@id int)

returns int

as

begin

return (select sum(id) from sysobjects...

Good....