The name "xxxx" not permitted in the Context (insert) ???

[Adithya Adi]

I'm a beginner of SQL Server. I'm using SQL Server Management Studio Express.

I created table with 3 fields

Table Name = Add_Tax_Group
tax_id as int,
tax_nm as varchar(50),
tax_rate numeric(18,2)

(Primary Key Not set)

I created Procedure for the insertion--

create procedure add_txgrp
@tax_id as int,
@tax_nm as varchar(50)
as
insert into add_tax_group
values(tax_id,tax_nm)(@tax_id,@tax_nm)

But while executing in the database an error occurs, it shows

"Msg 128, Level 15, State 1, Procedure add_txgrp, Line 6
The name "tax_id" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted."

So could anyone help me how to solve this..

[Sivaranjani]

Check your insert Query inside the Sp.

create procedure add_txgrp
@tax_id as int,
@tax_nm as varchar(50)
as
insert into Add_Tax_Group(tax_id,tax_nm) values(@tax_id,@tax_nm)

[Adithya Adi]

yup,, right!!,, thank you, :)