Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 4th, 2012  |  syntax: None  |  size: 1.38 KB  |  hits: 9  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Data Modeling: Supertype / Subtype
  2. SELECT Name FROM Party WHERE PartyId = FanId
  3.        
  4. CREATE TABLE [dbo].[XREFBandMembers](
  5.     [MemberID] [int] NOT NULL,
  6.     [BandId] [int] NOT NULL,
  7.  CONSTRAINT [PK_XREFBandMembers] PRIMARY KEY CLUSTERED
  8. (
  9.     [MemberID] ASC,
  10.     [BandId] ASC
  11. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  12. ) ON [PRIMARY]
  13. GO
  14.  
  15. CREATE TABLE [dbo].[XREFBandFans](
  16.     [FanId] [int] NOT NULL,
  17.     [BandId] [int] NOT NULL,
  18.  CONSTRAINT [PK_XREFBandFans] PRIMARY KEY CLUSTERED
  19. (
  20.     [FanId] ASC,
  21.     [BandId] ASC
  22. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  23. ) ON [PRIMARY]
  24.  
  25. CREATE TABLE [dbo].[People](
  26.     [Id] [int] IDENTITY(1,1) NOT NULL,
  27.     [Name] [nvarchar](100) NOT NULL,
  28.  CONSTRAINT [PK_People] PRIMARY KEY CLUSTERED
  29. (
  30.     [Id] ASC
  31. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  32. ) ON [PRIMARY]
  33.  
  34. CREATE TABLE [dbo].[Bands](
  35.     [Id] [int] IDENTITY(1,1) NOT NULL,
  36.     [Name] [nvarchar](50) NOT NULL,
  37.  CONSTRAINT [PK_Bands] PRIMARY KEY CLUSTERED
  38. (
  39.     [Id] ASC
  40. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  41. ) ON [PRIMARY]
  42. GO
create a new version of this paste RAW Paste Data