Incorrect syntax near ',' 
    INSERT INTO [Temp].[dbo].[Student]
        ([Fname], [Lname], [Gender])
        VALUES 
        (N'Aname', N'Alname', N'Male')
        GO

This codes workes fine but when I try to add multiple values it gives me an error

   

    USE TEMP
    GO
   
    INSERT INTO [Temp].[dbo].[Student]
    ([Fname], [Lname], [Gender])
    VALUES 
    (N'Aname', N'Alname', N'Male'),
    (N'Bname', N'Blname', N'Male')
    GO

**Error: Incorrect syntax near ','.**

Thanks for help!

Incorrect syntax near ',' 
===

    INSERT INTO [Temp].[dbo].[Student]
        ([Fname], [Lname], [Gender])
        VALUES 
        (N'Aname', N'Alname', N'Male')
        GO

This codes workes fine but when I try to add multiple values it gives me an error

   

    USE TEMP
    GO
   
    INSERT INTO [Temp].[dbo].[Student]
    ([Fname], [Lname], [Gender])
    VALUES 
    (N'Aname', N'Alname', N'Male'),
    (N'Bname', N'Blname', N'Male')
    GO

**Error: Incorrect syntax near ','.**

Thanks for help!
