Skip to content

Instantly share code, notes, and snippets.

@DmitrySikorsky
Created November 20, 2018 10:39
Show Gist options
  • Save DmitrySikorsky/0e11c8ee2ba50aa957ca323c3db5b4ee to your computer and use it in GitHub Desktop.
Save DmitrySikorsky/0e11c8ee2ba50aa957ca323c3db5b4ee to your computer and use it in GitHub Desktop.
CREATE TYPE [dbo].[ChildItemsType] AS TABLE(
[Id] [int] NOT NULL,
[ParentItemId] [int] NOT NULL,
[SomeProperty1] [nvarchar](64) NOT NULL,
[SomeProperty2] [nvarchar](64) NOT NULL,
[SomeProperty3] [nvarchar](64) NOT NULL
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment