Gaby Abed (7/9/2009)

---

For the same reason "long" is such a short word? 🙂

English is a funny language. For...

Gaby Abed (7/9/2009)

---

Jan Van der Eecken (7/9/2009)

---

10 out of 10 for this...

arthykannan (7/6/2009)

---

You guys shuck. every time we have to go and register or it says we have to go and click the freaking link. and the email doesnt get...

GSquared (7/6/2009)

---

RBarryYoung (7/3/2009)

---

RBarryYoung (7/3/2009)

---

...

And most of all, that people would say, or describe themselves as doing, something obnoxious or offensive and when they got called on it instead of admitting...

OK, I assume that you do not want/need either the service or the queue, right? They're just a leftover from the demo install?

If so, then proceed as follows:

1) DROP...

You just specify them. The problem with optional parameters in User Defined Functions is that you can't not specify them: so they are not really "optional".

Yep, an INSERT..SELECT. Try it like this:

INSERT Into ccc(caa, cbb)

SELECT aa, bb

FROM bb

I think you'll agree, that's a bit easier. And it's loads faster.

Of course I'm going on Vacation in the morning... So, you want to look for things like adding string literals onto the front of your NVarchar(MAX):

SELECT @BigStr...

WayneS (7/5/2009)

---

Ghanta (7/5/2009)

---

Guys I made the variable @nsql nvarchar(max) to be used for dynamic sql. When I execute using sp_executesql, it throws me error and seems like the sql that...

Thing is, I'm not sure that its true about sp_ExecuteSql either. Here's a script that demonstrates both successfully executing a string WAY over 4000 characters:

Declare @sql as nvarchar(MAX)

set @sql...

Ghanta (7/5/2009)

---

Guys I made the variable @nsql nvarchar(max) to be used for dynamic sql. When I execute using sp_executesql, it throws me error and seems like the sql that it...

??? I'm sure...

Jeff Moden (7/5/2009)

---

Ok... first, it's a...

You want to use SELECT INTO for this, as it...

Some aspects of this a relatively easy. But other aspects are really hard. And the hardest part is being sure that you haven't actually missed anything because there...