Tricky Question.

I had chosen char(1) instead of varchar(1) because thats what it actually is, a fixed length string.

And I had chosen char(1) instead of nchar(1) because I think it is...

Now that makes me feel honored:Wow:

...

Jack Corbett (4/16/2009)

---

Just a side note. If case is that important to the application then, in my opinion, the application should be upper-casing the string in the first place....

Just for additional clarification:

CASE Fieldxy WHEN NULL THEN ...

This case will always evaluate to false

the correct code in this case would be:

CASE WHEN Fieldxy IS NULL THEN ...

Here you can...

Carlo Romagnano (4/16/2009)

---

Correct answer is 1-25:

exec sp_helptext sp_addmessage

in the output search for @severity and you'll find this piece of code that is the law.

...

I think the confusion is related to the fact that you cannot use severity level 0 for use in sysmessages.

- Severity Levels that can be specified with RAISERROR range from...

RBarryYoung (4/15/2009)

---

Sorry, Christian, I...

Bruce W Cassidy (4/15/2009)

---

Having said all of that, I'm curious as to how MERGE (mentioned earlier by Joe Celko) could be used in this scenario. I believe that as...

Bruce W Cassidy (4/14/2009)

---

Christian Buettner

---

In one of my data import apps (Oracle to SQL Server), I use temp tables with varchar(500) fields to ensure all data can be imported successfully...

RBarryYoung (4/14/2009)

---

Christian Buettner (4/14/2009)

---

RBarryYoung (4/14/2009)

---

Christian Buettner (4/14/2009)

---

I'll just jump in and risk making a fool of myself.

In one of my data import apps (Oracle to SQL Server), I use temp...

RBarryYoung (4/14/2009)

---

Christian Buettner (4/14/2009)

---

I'll just jump in and risk making a fool of myself.

In one of my data import apps (Oracle to SQL Server), I use temp tables with varchar(500)...

I'll just jump in and risk making a fool of myself.

In one of my data import apps (Oracle to SQL Server), I use temp tables with varchar(500) fields to ensure...

Hi Chris,

Very fancy stuff that you posted. Wasn't even aware you could do such fancy stuff in an ORDER BY:-).

Actually I did want to tell you that your queries did...

GSquared (4/6/2009)

---

If you do this:

update #test

set col1 = isnull(col1,0),

col2 = isnull(col2,0),

col3 = isnull(col3,0),

col4 = isnull(col4,0),

col5 = isnull(col5,0),

col6 = isnull(col6,0),

col7 = isnull(col7,0),

col8 = isnull(col8,0)

;with...

Nope, as I just wrote in another post, solving this with SQL is probably more or less torture.

And I think we have already...