SQL Code Completion for INSERT INTO for a declared variable AS a user defined type
CREATE TYPE dbo.MyType AS TABLE
(
MyTypeId UNIQUEIDENTIFIER NOT NULL
, MyTypeContent1 VARCHAR(20) NOT NULL
);
DECLARE @a AS dbo.MyType
INSERT INTO @a --> Tab-Tab expands just like it does for other table types.
3
votes
Stephen
shared this idea