tommyh (11/16/2010)

---

Carlo Romagnano (11/16/2010)

---

I should remember implicit cast using CASE clause.

Good question. I refreshed implicit cast.

In sql2000, it gives error also with SET @sortby='Date1'. (Syntax error converting datetime from character...

I should remember implicit cast using CASE clause.

Good question. I refreshed implicit cast.

In sql2000, it gives error also with SET @sortby='Date1'. (Syntax error converting datetime from character string.), not in...

Oleg Netchaev (11/15/2010)

---

Carlo,

Please check compat level of your SQL Server 2005 AdventureWorks database. If the level...

Execute the batch without the 'GO'

EXEC uspLogError

SELECT st.text QueryText,objtype

FROM sys.dm_exec_cached_plans

CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st

WHERE text LIKE N'%uspLogError%'

Result:

CREATE PROCEDURE [dbo].[uspLogError] ....,'Proc'

EXEC uspLogError SELECT st.text QueryText FROM...

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...