i have written some code to help developers spend less time on scripting basic statements.

the first link is a demonstration of this:

[/url]

the second one is the actual code that uses metadata to easily script select, insert and update statements:

[/url]

the next script is useful for deleting the statements produced by the above code, useful for when changes like a new table or column have been introduced and its time to redefine the stored procs to match:

[/url]