For example, in SQL Server 2014 default constraints are supported, but check constraints are not. Like memory-optimized tables, table variables do not support parallel plans. Like memory-optimized ...

INCLUDE SQL Server ... is used to define a table in CREATE TABLE. The table declaration includes column definitions, names, data types, and constraints. The only constraint types allowed are PRIMARY ...

Now that we understand how SQL*Plus variables are stored, let's examine a real-world example. Here's an example from a STATSPACK report that reports on table growth as a function of the block size ...

I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass table variables (and the data in them) into stored procedures and functions.