Very bad worded question:

This is related to SQL Server caching. What should be the output of following T-SQL query:

USE AdventureWorks2008R2

GO

EXEC uspPrintError

GO

SELECT st.text QueryText

FROM sys.dm_exec_cached_plans...

Jeff Kunkel-812485 (11/12/2010)

---

Happy Friday All!!!

However, as I mostly support another vendors databases, I am seeing more developers move the business logic into the application code and out of stored procedures...

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.