SQL Server 2008 introduces the ability to pass ... Also, you cannot use table variables as OUTPUT parameters — you can only use table variables as input parameters. Putting my new table variable ...

This should be simple, but I'm a bit confused by these two.<br><br>As I understand it your stored procedure can have 3 values/paramater types:<br>Input paramters (which are obviously what you pass ...