Using the table Data Type
The table data type can be used to define table variables in stored procedures and elsewhere in SQL code. Table variables are defined similarly to regular tables, except you define them using a DECLARE statement, rather than using CREATE TABLE:
DECLARE @table_variable TABLE ({ column_definition | table_constraint } [ ,...n ])
The following simple example shows how to use a table variable in a stored procedure:
-- proc to get year-to-date sales for all books published since specified date-- with ytd_sales greater than specified thresholdcreate proc tab_var_test @orderDate datetime = null, @sales_minimum ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
