O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required