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.