No... and today pretty much stunk for doing...

Heh... beat you to it. See you tomorrow night.

LOL!!! Now, that just figures... :hehe:

Heh... it actually doesn't really matter at all... here's why...

SELECT TOP 1000

REPLACE(REPLICATE('=',t.N)+'9','9','88') AS R,

...

Test it... you'll find out differently... no warning.

Same holds true for the following...

SELECT REPLACE(REPLICATE('=',7999)+'9','9','88')

Truncation with no warning.

So, there is truncation with no warning for both. To me, that...

Sorry... getting a bit tired and, like you said, shouldn't have posted "the short answer". 😀

What happens with the following in SQL Server 2000? 2005?

SELECT STUFF(REPLICATE('=',8000),1,0,'=')

Greg Edwards (1/14/2009)

---

I'm thinking Gail is going who needs a 44 Magnum, when you have H&H's around.

Maybe you better think about upgrading Jeff. I'd hate for you to bring a...

Heh... I've already seen all of those logical discussions above. Although very well founded, I still just happen to disagree with them.

Heh... that's what's cool about discussions on forums... I get to disagree and not hurt anyone's feelings. 😛

Personally, I'd prefer to see the function be a little smarter and, yeah,...

I see that mistake alot, as well... especially by Oracle programmers because you can't write an Oracle trigger using what looks like set based code. You write the trigger...

Thanks for the feedback Felix. What did you end up doing?

John Dempsey (1/14/2009)

---

I'm with you Jeff. I always use BEGIN TRANSACTION when performing a manual delete. I also use it when I am doing an update also, of...

Heh... just couldn't help myself on that one...

Like Gail pointed out to this rubber, this isn't the first time he's been a real jerk about...

Chris Morris (1/14/2009)

---

Jeff Moden (1/13/2009)

---

Oooohhhh.... I might be in trouble... I've got buckets full...