Alexander Kuznetsov (11/13/2008)

---

Solomon Rutzky (11/13/2008)

---

3) To test any result...

Roger Fleig (11/13/2008)

---

A really strong plus is if the wiki format supports revision history, style guidelines and annotations like wikipedia. If it has true multi-database sql language support then...

Thanks, I appreciate it. 🙂

Take care,

Solomon.......

Alexander Kuznetsov (11/13/2008)

---

How would you test the following cases:

- my stored procedure returns an unordered result set;

- my stored procedure returns two result sets;

- ...

greenantim (10/28/2008)

---

I tried to use this on SQL2005 but every time I add the trigger, the trace ends without any indication of what caused it to fail. Has anyone...

I certainly agree that each group needs to try new methods of building software to see what works for them. While Agile is a buzz-word these days, it really...

Another option is to use CLR, even though not everyone is a fan of that option. The SQL# library that is available at http://www.SQLsharp.com/ has functions to do this....

nice article....2 limitations to add to the list:

1) as "sbateman" mentioned, Table Variables cannot be used in SELECT ... INTO statements

2) Table Variables cannot be used in sub-processes, such as:...

cs_troyk (6/27/2008)

---

Good article on a good use of the CLR. Nice to include code samples. This line from the article, though, gave me a bit of a chuckle:

"We have quite...

Yeah, it really did constrain me and I truly did try to find a...

Jeff Moden (6/25/2008)

---

Very good article... you did a heck of a good job on it. 🙂

Just a couple of observations...

You did all of this just because BCP won't export...

andreq1 (6/25/2008)

---

My situation may be a little different, but maybe you can provide some insight. There is a plan to import all (with exceptions) user tables from a Progress database...

I have a pretty good idea of what is wrong. It is either this:

((CONVERT(INT,...

Do you have it searching JobSteps? Which is the default. If so, try setting that parameter to 0...

david.murden (5/29/2008)

---

Have you any idea why i would be getting a String or Binary data would be Truncated error? I have poured over the script for quite a while and...