Unit testing stored procedures

8 Jul 2005 12:35 AM

John

What is the best way to unit test stored procedures? I've got some which
generate anywhere from 250k to 3million records each. The ideas which come
to mind are horribly inefficient.

Any advice or URLs would be greatly appreciated.

Thanks in advance.

--
Regards,
John MacIntyre
http://www.johnmacintyre.ca
Specializing in; Database, Web-Applications, and Windows Software

8 Jul 2005 1:43 AM

Aaron Bertrand [SQL Server MVP]

Do you mean test for accuracy (correct data, correct order), or load test
(to see if concurrent usage will bring your server to its knees)?

Show quote

"John" <Please.Re***@To.the.group.com> wrote in message
news:uVlI8T1gFHA.1248@TK2MSFTNGP12.phx.gbl...
> What is the best way to unit test stored procedures? I've got some which
> generate anywhere from 250k to 3million records each. The ideas which
come
> to mind are horribly inefficient.
>
> Any advice or URLs would be greatly appreciated.
>
> Thanks in advance.
> --
> Regards,
> John MacIntyre
> http://www.johnmacintyre.ca
> Specializing in; Database, Web-Applications, and Windows Software
>
>

8 Jul 2005 1:57 AM

John

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:eDCF$51gFHA.576@TK2MSFTNGP15.phx.gbl...
> Do you mean test for accuracy (correct data, correct order), or load test
> (to see if concurrent usage will bring your server to its knees)?
>

I mean correct data.