charlesz (2/2/2009)

---

Second, NVarchar(MAX) and Varchar(MAX) can only hold up to 65535 bytes ( The number posted by Gail Shaw was wrong).

Our product DB-WAN Accel communicates with SQL Server using TDS...

BWAA-HAAA! So what? Heh... Consider this... If the people who wrote T-SQL and other languages got...

Sanjay (2/2/2009)

---

I got following error while compiling this x_TruncateTable proc:

Server: Msg 197, Level 15, State 1, Procedure x_TruncateTable, Line 126

EXECUTE cannot be used as a source when inserting into a...

benlatham (2/3/2009)

---

I agree in general that TSQL should be used to do all the work but in...

kevriley (2/3/2009)

---

Jeff Moden (2/2/2009)

---

I can't remember exactly what the phrase in the returned data was, but I've had this happen before. Turned out that one of the "switches" on...

ghughes (2/2/2009)

---

ok, I give up. I defer to everyone greater judgement in the matter. Make perfect sense. I have created table......thank you for the help.

in...

... and, if your programs are running slowly, the best tip I can give you is to make the paradigm shift from thinking in rows (RBAR) to thinking in set...

http://www.sqlservercentral.com/Forums/Topic627665-338-1.aspx

Go for it. 😉

Bruce W Cassidy (2/2/2009)

---

[font="Verdana"]Is the MyDateColumn unique? Because if it's not, the second form could return more than one row.

Ooops, really should read all of the replies before posting....

Max (2/2/2009)

---

Only problem was that the pig didn't last that long - minor omission though, everyone give Jeff a round...

Any bets on that?

DECLARE @test-2 VARCHAR(MAX),

...

ghughes (2/2/2009)

---

ok, you are right. At the time I was swamped and trying to fix the next dozen problems on my list. I cant find my link...

It had to happen, someday. It's funny as hell that's...

Heh... bad day, Gus? 😉