Thank you Goldie - it's always nice when people post back to let us know that we helped 🙂

I felt fairly safe using a 2008-only feature since this is the...

Jeff Moden (8/6/2009)

---

Darned sorry about that, Goldie. I answered too quickly.

You would think that Microsoft would allow you to return data from the "from_table_name" on an insert like they...

Hey Satish,

Many thanks for the comprehensive reply, and for the extra details. I should make it clear that I am not at all anti-XML; I use it frequently wherever...

TheSQLGuru (8/7/2009)

---

If you have scalar UDFs on your system that are causing slowdowns then eliminating those will likely be the only (or at least major) thing that truly improves overall...

Jeff Moden (8/5/2009)

---

I don't know why they even bothered except that every language seems to have one and many of them have the same problem. Closer to being perfect...

:laugh:

--- deleted ---

(duplicate post)

Could the OP have made any less effort in that thread?

Bob Hovious (8/7/2009)

---

Thanks, Jack. I just tried to download it again and no luck. Sounds like a fun problem, maybe someone else can help...

RBarryYoung (8/7/2009)

---

Bob Hovious (8/7/2009)

---

Warning. Don't click on the link above. Save it and open it with notepad or some other editor first. ...

You don't have to be psychic to help out around here - but it certainly helps.

Actually it's quite spooky how often people post questions about things that have happened to...

Josh (8/7/2009)

---

Wouldnt't a varchar(2) actually use more space than a char(2). I thought varchar is the number of characters + 2 bytes. So for instance '' would use...

I am forced to use Vista at work - I miss NET SEND!

Books Online - TRUNCATE TABLE permissions

---

The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the...

CREATE FUNCTION dbo.F (@Input INTEGER)

RETURNS BIGINT

WITH SCHEMABINDING

AS

BEGIN

RETURN CONVERT(BIGINT, @Input) * CONVERT(BIGINT, 2);

END

GO

CREATE TABLE dbo.Test

(

Number INTEGER NOT...