Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
Kevin,
>To answer your other question, it has two chapters on writing stored procedures in T-SQL 2005. I disagree that SPT has more flexibility. [I'm not opposed to SPT, I just stress SPs as a general practice].
SPT is more flexible as it will execute any SQL you pass through. With SP you can only execute what has been implemented in the SP. So ad-hoc queries are not posible with SP (unless of course you pass a SQL command that gets executed in the SP :)).
Walter,
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only