Updating table variables
Math Works Machine Translation The automated translation of this page is provided by a general purpose third party translator tool.
Functions and variables can be declared to be of type table.table variables can be used in functions, stored procedures, and batches.In table variable the constraint types allowed are PRIMARY KEY, UNIQUE, NULL, and CHECK but they must be incorporated with the creation of the table in the DECLARE statement. Table variable Can only have indexes that are automatically created with PRIMARY KEY & UNIQUE constraints as part of the DECLARE statement.We can return a table variable from user-defined function.
To declare variables of type table, use DECLARE @local_variable.Is the same subset of information that is used to define a table in CREATE TABLE.