asked on 10/5/2011

Insert

Hi,
I try to insert in table "pt' but gives me erro
insert into pt
(ptid,vr,Title,TyppeID,pn)
values (@ReportId,"M1","T12","List",2)

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

Microsoft SQL Server 2008 Microsoft SQL Server 2005

Last Comment

samprg

10/5/2011

Kent Dyer

10/5/2011

I don't think you can place your own values in the ID as it is usually an auto-created, auto-incremented ID and ususally created with an Index in a SQL table..

Try this instead:

insert into pt
        (vr,Title,TyppeID,pn)
 values ("M1","T12","List",2)

Open in new window

On second thought, you need to back up and review the datatypes for:
vr
Title
TyppeID
pn

HTH,

Kent

mimran18

10/5/2011

Hi,
Here we go.
http://blog.sqlauthority.com/2007/03/22/sql-server-fix-error-msg-128-the-name-is-not-permitted-in-this-context-only-constants-expressions-or-variables-allowed-here-column-names-are-not-permitted/

samprg

10/5/2011

ASKER

"ptid" is FK, not ID, I need to insert into table

ASKER CERTIFIED SOLUTION

Pratima

10/5/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

samprg

10/5/2011

ASKER

Thanks