Hi Guys

i had a similar problem whereby i needed to automatically drop and create a job to execute a stored proc and i got the MSX error.

in my drop statement...

I've almost 'grown up' (professionally) with microsoft's sql standard, thus I'm not too familiar with ANSI standard.

I've played with COALESCE before, but I find ISNULL is sufficient for my requirements;...

i was really hoping that i would find an article on this subject in SQLServerCentral and thank goodness i found your article, great!

you just saved me many hours of hunting!

excellent...

I'm glad to see my thinking (from a SQL 2000 point of view) was at least in line with some other folks as well.

Unfortunately this didn't get us the points...

Hi there

I work in a SQL 2000 developer edition. when I run the provided script, it runs successfully returning rows 1 through 6.

Only if I run the script, without the...

Tao Klerks (1/22/2009)

---

I don't mean to be overly picky (it's a good question, the intention was clear, and I got my point 🙂 ), but Truncate Table will not necessarily...

I find working with GUIDs very cumbersome and in the application that I inherented at my company, I haven't seen any advantage of using them, normal "int with identity(1, 1)...

That is quite interesting bit of info

DiverKas (12/10/2008)

---

I selected True and was told I got it wrong. However, if I choose to make a column a GUID column, choose identity and select it to be...

I seem to have taken the "append" piece out of the equation :ermm:......

This question got me!

Well done muzahm

The set ansi-nulls off could off course be debated, but still, good question.

The first if I had no problem with, but the second one got...

Rob Shane (11/14/2008)

---

Marius Els (11/14/2008)

---

that...

that is maybe not a...

As i read through the code, i didn't even realize that the second insert could possibly have been intented to be outside the sp, so in my mind the table...

agreed this was an insightful question, well done!