Thursday 14 December 2017

MSSQL - Fix Error - Incorrect syntax near while inserting records into table

Watch solution on YouTube

to fix it replace
INSERT INTO [dbo].[Customers]
           ([FisrtName]
           ,[LastName])
     VALUES
           ('frank', 'sinatra')
           ('john', 'lennon')
GO

with
INSERT INTO [dbo].[Customers]
           ([FisrtName]
           ,[LastName])
     VALUES
           ('frank', 'sinatra'),
           ('john', 'lennon')
GO

No comments:

Post a Comment