Article information
Article relates to
Telerik Reporting
Created by
Stef
Last modified
October 4, 2014
Last modified by
USE AdventureWorks
GO
CREATE
PROCEDURE
dbo.Demo
AS
BEGIN
SET
NOCOUNT
ON
;
IF 1=0
FMTONLY
OFF
END
TABLE
#
Temp
(
ProductID
integer
NOT
NULL
,
Name
nvarchar(50)
COLLATE
DATABASE_DEFAULT
);
INSERT
INTO
([ProductID], [
])
SELECT
p.[ProductID], p.[
]
FROM
Production.Product
p
t.[
], t.[ProductID]
t
DROP
TYPE MemoryOptTabVar
as
[ProductID]
[
] nvarchar(50)
INDEX
IX_MemoryOptTabVar_ID NONCLUSTERED ([ProductID])
)
WITH
(MEMORY_OPTIMIZED =
dbo.MemoryOptTableVarExample
DECLARE
@MemOptVarTab MemoryOptTabVar ;
@MemOptVarTab ([ProductID], [
*
@MemOptVarTab
Resources Buy Try