These will behave just like temp tables. You may comparably carry things around in them. If you have a temp table of the same shape sprinkled across numerous stored procedures, perhaps you would have less overhead in using a custom data type. The challenge with these is that there is no way to run an ALTER command on them. If you want to change their shapes you have to drop all the stored procedures which use them, then drop them (the custom data types), and finally then recreate them.
No comments:
Post a Comment