All server side passing of table variable parameters are passed by reference, using the reference as a pointer to the table in the tempdb. EXECUTE usp_InsertBigScreenProducts @TableVariable ...