CREATE TYPE TABLE (Transact-SQL 2008)
Create TYPE Table is new opotion in SQL2008. It is very easy to handle and good to use in TSQ.
This is good as compare to TEMP Table.
Here is the Example:
Create Type MyTable as TABLE
(
ID INT IDENTITY (1,1),
NAME varchar(20),
ADRES VARCHAR(200)
)
DECLARE @T AS MyTable;
INSERT INTO @T( NAME, ADRES) VALUES( ‘RAGHU’, ‘KTM’ )
INSERT INTO [...]
Filed under: CREATE TYPE TABLE | Tagged: Author Raghunath Bhandari, Create Type MyTable as TABLE, CREATE TYPE TABLE, how to use the Table UDT, how to use Type Table in SQL 2008, MS SQL new feature Create type table, New feature in SQL 2008, SQL 2008, Table UDT, Table UDT as a parameter in SQL Stored Procedure. | Leave a Comment »
