Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[ItemLanguages](
- [ItemID] [INT] NOT NULL,
- [LanguageID] [INT] NOT NULL,
- [Name] [nvarchar](50) NULL,
- [Color] [nvarchar](50) NULL
- ) ON [PRIMARY]
- GO
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[Items](
- [ID] [INT] IDENTITY(1,1) NOT NULL,
- [code] [VARCHAR](50) NULL,
- CONSTRAINT [PK_Items] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[Languages](
- [ID] [INT] IDENTITY(1,1) NOT NULL,
- [LANGUAGE] [VARCHAR](50) NULL,
- CONSTRAINT [PK_Languages] PRIMARY KEY CLUSTERED
- (
- [ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE VIEW [dbo].[view1]
- AS
- SELECT dbo.Items.ID AS ItemID, dbo.Languages.ID AS LanguageID
- FROM dbo.Items CROSS JOIN
- dbo.Languages
- GO
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE VIEW [dbo].[resultsView]
- AS
- SELECT dbo.view1.ItemID, dbo.view1.LanguageID, dbo.ItemLanguages.Name, dbo.ItemLanguages.Color
- FROM dbo.ItemLanguages RIGHT OUTER JOIN
- dbo.view1 ON dbo.ItemLanguages.LanguageID = dbo.view1.LanguageID AND dbo.ItemLanguages.ItemID = dbo.view1.ItemID
- GO
- INSERT [dbo].[ItemLanguages] ([ItemID], [LanguageID], [Name], [Color]) VALUES (1, 1, N'Apple', N'Red')
- GO
- INSERT [dbo].[ItemLanguages] ([ItemID], [LanguageID], [Name], [Color]) VALUES (1, 2, N'Pomme', N'Rouge')
- GO
- INSERT [dbo].[ItemLanguages] ([ItemID], [LanguageID], [Name], [Color]) VALUES (2, 1, N'Orange', NULL)
- GO
- INSERT [dbo].[ItemLanguages] ([ItemID], [LanguageID], [Name], [Color]) VALUES (3, 1, N'Bannana', N'yellow')
- GO
- SET IDENTITY_INSERT [dbo].[Items] ON
- GO
- INSERT [dbo].[Items] ([ID], [code]) VALUES (1, N'item1')
- GO
- INSERT [dbo].[Items] ([ID], [code]) VALUES (2, N'item2')
- GO
- INSERT [dbo].[Items] ([ID], [code]) VALUES (3, N'item3')
- GO
- INSERT [dbo].[Items] ([ID], [code]) VALUES (4, N'item4')
- GO
- SET IDENTITY_INSERT [dbo].[Items] OFF
- GO
- SET IDENTITY_INSERT [dbo].[Languages] ON
- GO
- INSERT [dbo].[Languages] ([ID], [LANGUAGE]) VALUES (1, N'English')
- GO
- INSERT [dbo].[Languages] ([ID], [LANGUAGE]) VALUES (2, N'French')
- GO
- INSERT [dbo].[Languages] ([ID], [LANGUAGE]) VALUES (3, N'German')
- GO
- SET IDENTITY_INSERT [dbo].[Languages] OFF
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
- Begin DesignProperties =
- Begin PaneConfigurations =
- Begin PaneConfiguration = 0
- NumPanes = 4
- Configuration = "(H (1[32] 4[24] 2[7] 3) )"
- End
- Begin PaneConfiguration = 1
- NumPanes = 3
- Configuration = "(H (1 [50] 4 [25] 3))"
- End
- Begin PaneConfiguration = 2
- NumPanes = 3
- Configuration = "(H (1 [50] 2 [25] 3))"
- End
- Begin PaneConfiguration = 3
- NumPanes = 3
- Configuration = "(H (4 [30] 2 [40] 3))"
- End
- Begin PaneConfiguration = 4
- NumPanes = 2
- Configuration = "(H (1 [56] 3))"
- End
- Begin PaneConfiguration = 5
- NumPanes = 2
- Configuration = "(H (2 [66] 3))"
- End
- Begin PaneConfiguration = 6
- NumPanes = 2
- Configuration = "(H (4 [50] 3))"
- End
- Begin PaneConfiguration = 7
- NumPanes = 1
- Configuration = "(V (3))"
- End
- Begin PaneConfiguration = 8
- NumPanes = 3
- Configuration = "(H (1[56] 4[18] 2) )"
- End
- Begin PaneConfiguration = 9
- NumPanes = 2
- Configuration = "(H (1 [75] 4))"
- End
- Begin PaneConfiguration = 10
- NumPanes = 2
- Configuration = "(H (1[66] 2) )"
- End
- Begin PaneConfiguration = 11
- NumPanes = 2
- Configuration = "(H (4 [60] 2))"
- End
- Begin PaneConfiguration = 12
- NumPanes = 1
- Configuration = "(H (1) )"
- End
- Begin PaneConfiguration = 13
- NumPanes = 1
- Configuration = "(V (4))"
- End
- Begin PaneConfiguration = 14
- NumPanes = 1
- Configuration = "(V (2))"
- End
- ActivePaneConfig = 0
- End
- Begin DiagramPane =
- Begin Origin =
- Top = 0
- Left = 0
- End
- Begin Tables =
- Begin Table = "ItemLanguages"
- Begin Extent =
- Top = 6
- Left = 38
- Bottom = 160
- Right = 191
- End
- DisplayFlags = 280
- TopColumn = 0
- End
- Begin Table = "view1"
- Begin Extent =
- Top = 6
- Left = 246
- Bottom = 126
- Right = 397
- End
- DisplayFlags = 280
- TopColumn = 0
- End
- End
- End
- Begin SQLPane =
- End
- Begin DataPane =
- Begin ParameterDefaults = ""
- End
- Begin ColumnWidths = 9
- Width = 284
- Width = 1500
- Width = 1500
- Width = 1500
- Width = 1500
- Width = 1500
- Width = 1500
- Width = 1500
- Width = 1500
- End
- End
- Begin CriteriaPane =
- Begin ColumnWidths = 11
- Column = 1440
- Alias = 900
- Table = 1170
- Output = 720
- Append = 1400
- NewValue = 1170
- SortType = 1350
- SortOrder = 1410
- GroupBy = 1350
- Filter = 1350
- Or = 1350
- Or = 1350
- Or = 1350
- End
- End
- End
- ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'resultsView'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'resultsView'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
- Begin DesignProperties =
- Begin PaneConfigurations =
- Begin PaneConfiguration = 0
- NumPanes = 4
- Configuration = "(H (1[35] 4[26] 2[8] 3) )"
- End
- Begin PaneConfiguration = 1
- NumPanes = 3
- Configuration = "(H (1 [50] 4 [25] 3))"
- End
- Begin PaneConfiguration = 2
- NumPanes = 3
- Configuration = "(H (1 [50] 2 [25] 3))"
- End
- Begin PaneConfiguration = 3
- NumPanes = 3
- Configuration = "(H (4 [30] 2 [40] 3))"
- End
- Begin PaneConfiguration = 4
- NumPanes = 2
- Configuration = "(H (1 [56] 3))"
- End
- Begin PaneConfiguration = 5
- NumPanes = 2
- Configuration = "(H (2 [66] 3))"
- End
- Begin PaneConfiguration = 6
- NumPanes = 2
- Configuration = "(H (4 [50] 3))"
- End
- Begin PaneConfiguration = 7
- NumPanes = 1
- Configuration = "(V (3))"
- End
- Begin PaneConfiguration = 8
- NumPanes = 3
- Configuration = "(H (1[56] 4[18] 2) )"
- End
- Begin PaneConfiguration = 9
- NumPanes = 2
- Configuration = "(H (1 [75] 4))"
- End
- Begin PaneConfiguration = 10
- NumPanes = 2
- Configuration = "(H (1[66] 2) )"
- End
- Begin PaneConfiguration = 11
- NumPanes = 2
- Configuration = "(H (4 [60] 2))"
- End
- Begin PaneConfiguration = 12
- NumPanes = 1
- Configuration = "(H (1) )"
- End
- Begin PaneConfiguration = 13
- NumPanes = 1
- Configuration = "(V (4))"
- End
- Begin PaneConfiguration = 14
- NumPanes = 1
- Configuration = "(V (2))"
- End
- ActivePaneConfig = 0
- End
- Begin DiagramPane =
- Begin Origin =
- Top = 0
- Left = 0
- End
- Begin Tables =
- Begin Table = "Items"
- Begin Extent =
- Top = 8
- Left = 226
- Bottom = 110
- Right = 377
- End
- DisplayFlags = 280
- TopColumn = 0
- End
- Begin Table = "Languages"
- Begin Extent =
- Top = 6
- Left = 38
- Bottom = 108
- Right = 189
- End
- DisplayFlags = 280
- TopColumn = 0
- End
- End
- End
- Begin SQLPane =
- End
- Begin DataPane =
- Begin ParameterDefaults = ""
- End
- Begin ColumnWidths = 9
- Width = 284
- Width = 1500
- Width = 1500
- Width = 1500
- Width = 1500
- Width = 1500
- Width = 1500
- Width = 1500
- Width = 1500
- End
- End
- Begin CriteriaPane =
- Begin ColumnWidths = 11
- Column = 1440
- Alias = 1620
- Table = 1170
- Output = 720
- Append = 1400
- NewValue = 1170
- SortType = 1350
- SortOrder = 1410
- GroupBy = 1350
- Filter = 1350
- Or = 1350
- Or = 1350
- Or = 1350
- End
- End
- End
- ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'view1'
- GO
- EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'view1'
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement