Yeah, I can't wait until hackers get into car OSs and make the engines quit, shift into reverse on the freeway, floor the accelerator in the driveway, maybe even self-start...

GilaMonster (12/19/2012)

---

pdanes (12/19/2012)

---

But what about such a table as a parameter? No business logic, but at least the fields would be strongly typed. I don't know if I would get...

Oh, yeah. Oops. You could use multiple rows and put an...

David Webb-200187 (12/19/2012)

---

You could send a fixed terminating character on the end of your variable parameters and check to see if it is actually the last character in the parameter....

GilaMonster (12/19/2012)

---

pdanes (12/19/2012)

---

Don't you get a performance hit from passing a table over the network, rather than a single string? And I think the server would parse it a lot...

SQLKnowItAll (12/19/2012)

---

Don't you get a performance hit from passing a table over the network, rather than a single string? And I think the server would parse it a lot faster...

SQLKnowItAll (12/19/2012)

---

I would say that in the case where a parameter is passed to the stored proc that does not match the size of a particular column (i.e. a delimited...

Grant Fritchey (12/19/2012)

---

pdanes (12/19/2012)

---

Well, the data structure...

GilaMonster (12/19/2012)

---

pdanes (12/19/2012)

---

GilaMonster (12/19/2012)

---

I'm going to be unpopular here but...

Dependency analysis?

Regression testing?

Unit tests?

Sure, making all parameters and variables varchar(max) would work. Shall we make all table columns varchar max too...

Jeff Moden (12/19/2012)

---

So, use the +1 method I told you about if there are any doubts. Either that or remember the hair pulling you just went through and make...

Well, the data structure may be a...

GilaMonster (12/19/2012)

---

I'm going to be unpopular here but...

Dependency analysis?

Regression testing?

Unit tests?

Sure, making all parameters and variables varchar(max) would work. Shall we make all table columns varchar max too (if not,...

So I've been...

MyDoggieJessie (12/19/2012)

---

I don't believe there's a way within SQL to prohibit the truncation of the strings when it's assigned to the variable. How is this proc called? If...

GSquared (12/3/2012)

---

There's no need to convert Like to = if it doesn't include any wildcards. Just use Like. SQL Server will treat it as an equality test if...