>
But if it's generated... how is it different than a SPT? By being a tad more reusable, i.e. you save a couple of kilobytes each call by sending the command string only once (but you lose some because there's some overhead - though that overhead is shorter than this message)? >
>No, they're different.
>
>
>Suppose I had five tables where I wanted to do paging - I could write a script that would generate the core logic for paging for each one. So I can write a script that generates the exact SP that I have on my blog, and use it to generate multiple scripts.
>
>I can still test in the SQL development environment - I'm not tied to the application tool for testing.
After posting, I realized that the main difference is in what is generating the SP(T). In my POV, a SPT is running a SQL statement composed by the app which uses the data (doesn't matter which tier does it). What's generating the SP?