SQL Server stored procedure - Insert syntax error

Question

I am trying to create a stored procedure to store data input from web forms to a SQL Server table. I can get the select statement for first_name to work correctly, but when I try add more Insert statements, I get a syntax error.

What am I doing wrong? Screenshot below. Thanks.

Looks like Microsoft SQL Server, from the use of square brackets. It's common for users of Microsoft SQL Server to call their RDBMS simply "SQL" as if there's no other implementation of the SQL language. I bet if they used a text editor, they'd call it "Word." — Bill Karwin
– Bill Karwin, Commented Mar 10, 2019 at 20:56
Microsoft SQL management studio 2017 (sorry i should have specified) — Pacman6000
– Pacman6000, Commented Mar 10, 2019 at 20:57
Edit the tags of your question to be more clear. Using tags appropriately helps you get answers from the people who know that product best, because they search for questions posted using that tag. sql-server is the most common tag for Microsoft SQL Server. — Bill Karwin
– Bill Karwin, Commented Mar 10, 2019 at 20:58

Derviş Kayımbaşıoğlu · Accepted Answer · 2019-03-10 21:09:23Z

2

remove the comma , before parantheses.

@email_email varchar(50),
                       ^^^

besides I believe that your insert statement is needed to be like

insert into dbo.users (first_name, last_name, email)
   values (@first_name, @last_name, @email_email)

answered Mar 10, 2019 at 21:09

Derviş Kayımbaşıoğlu

30.9k4 gold badges55 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server stored procedure - Insert syntax error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related