Not sure how I got the old version of the Question with the second set of PKs being 1, 1, 1, after Steve made the changes but I also had...

Ah yes, my "favorite" bit of SQL syntax

select 0 [A]

A fun bug to find when I accidentally delete a comma and then try to figure out what's wrong with...

Never mind advice on forum posting, excellent though it is. I bookmarked this article as "Export table contents into flat file."

Next thing I'll do is write a query to...

Excellent writeup.

Like others who posted here, I have worked with indexes for a long time, and I can't say that I actually learned something new at Level 1, but this...

😀 That nearly got me, too!

Very good question, especially since it highlights that the BOL don't necessarily mean...

I'm not sure if this board leans toward opening new topics or pulling up old ones, but I wanted to share a really bizarre experience related to this issue.

I am...

I wonder if it's because ISNUMERIC disregards the position of the comma? For instance,

isnumeric('123,45.7')

returns...

Ah! No, haven't thought of that, thank you. It does look...

Thanks, Elliott! I don't need to change the mappings at run time. I just want to import them from outside the SSIS designer, so I don't have to tediously type...

Yes, xp_dirtree worked on local folder in 2005.

Anyway, mystery is solved, kinda. I found today that all SQL Server services are stopped. :crazy: This is a new server, and...

This seems to work:

SELECT F.ColA

FROM To_upd T join From_upd F on charindex(T.ColA, F.Col_02) > 0

WHERE F.Col_01 = '2'

john.arnott (3/23/2009)

---

What's happening here is that comparisons with NULL always return "false". Not even NULL compares true to NULL. So, even though NULL (row 4) doesn't contain string "del",...

Great article, thanks!

Thank you, Krishna.

Gila, that's what I thought, but then the panic struck.

I ended up just running a restore command. Luckily, one of the two "suspect" databases is repopulated daily...

I got it right, but now I realize it was almost by accident.

Irish Flyer (2/11/2009)

---

Given the inconsistancies noted, I guess it brings home the point that one should be...