Skip to content

Instantly share code, notes, and snippets.

@jinan-kordab

jinan-kordab/AddingTwoTestRecords.sql

Created October 16, 2018 02:24
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jinan-kordab/9a0681f611b72921c078a9fcfed1309f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jinan-kordab/9a0681f611b72921c078a9fcfed1309f to your computer and use it in GitHub Desktop.
Download ZIP
Adding two test records in SQL table for Dynamic Menu
Raw
AddingTwoTestRecords.sql
USE [NavMenuDB]
GO
SET IDENTITY_INSERT [dbo].[NavigationMenu] ON
GO
INSERT [dbo].[NavigationMenu] ([LinkId], [LinkLevel], [Linktype], [ParentLink], [LinkOrder], [LinkText], [HasChildren], [Class]) VALUES (1, 1, N'LINK', 0, 0, N'MENU A', 1, N'4|grid no-margin')
GO
INSERT [dbo].[NavigationMenu] ([LinkId], [LinkLevel], [Linktype], [ParentLink], [LinkOrder], [LinkText], [HasChildren], [Class]) VALUES (2, 1, N'LINK', 0, 1, N'MENU B', 1, N'4|inline-list')
GO
SET IDENTITY_INSERT [dbo].[NavigationMenu] OFF
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment