USE MASTER GO CREATE DATABASE FO GO USE FO GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[InvoiceLine]( [UnitPrice] [numeric](20, 12) NULL, [Quantity] [numeric](20, 12) NULL, [TrackId] [bigint] NULL, [InvoiceId] [bigint] NULL, [InvoiceLineId] [bigint] IDENTITY(1,1) NOT NULL, CONSTRAINT [PK_InvoiceLine] PRIMARY KEY CLUSTERED ( [InvoiceLineId] 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 INSERT INTO InvoiceLine (UnitPrice,Quantity,TrackId,InvoiceId,InvoiceLineId) VALUES (0.99,3,2,1,1);