I have a stored procedure that uses a paramater (which is the table name) I am running this sproc on. How can I run it on all my tables in the db I am on?
This is how I would run it:
exec sp_mysproc 'mytablename'
I have about 100 tables and don't want to change the table name in the command 100 times.