not a valid identifier - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

not a valid identifier

Author

Topic

helixpoint
Constraint Violating Yak Guru

291 Posts

Posted - 2008-12-12 : 12:01:13

ALTER PROCEDURE [dbo].[InsertMember]
(@dFields varchar(1000),
@dValues varchar(1000),
@id int OUTPUT)
AS

-- Create a variable @SQLStatement
DECLARE @SQLStatement varchar(1000)

-- Enter the dynamic SQL statement into the
-- variable @SQLStatement
SELECT @SQLStatement = 'INSERT INTO dbo.member
(' + @dFields + ')
VALUES (' + @dValues + ')'

PRINT @SQLStatement
-- Execute the SQL statement
EXEC @SQLStatement
Select @Id = @@identity

The print gives me:

INSERT INTO dbo.member
(txtEmail,FirstName,lastName,address1,city,state,country,zip,EmailNewsletter,htmlYes)
VALUES ('golffowlerjg@juno.com','glenn','fowler','','','KS','','',1,1)
Msg 203, Level 16, State 2, Procedure InsertMember, Line 23
The name 'INSERT INTO dbo.member
(txtEmail,FirstName,lastName,address1,city,state,country,zip,EmailNewsletter,htmlYes)
VALUES ('xxxxxx@juno.com','xxxx','xxxxx','','','KS','','',1,1)' is not a valid identifier.

If I copy the SQL into the query editor, it works

Dave
Helixpoint Web Development
http://www.helixpoint.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-13 : 00:37:48

[code]
ALTER PROCEDURE [dbo].[InsertMember]
(@dFields varchar(1000),
@dValues varchar(1000),
@id int OUTPUT)
AS

-- Create a variable @SQLStatement
DECLARE @SQLStatement varchar(1000)

-- Enter the dynamic SQL statement into the
-- variable @SQLStatement
SELECT @SQLStatement = 'INSERT INTO dbo.member
(' + @dFields + ')
VALUES (' + @dValues + ')'

PRINT @SQLStatement
-- Execute the SQL statement
EXEC (@SQLStatement)
Select @Id = @@identity
[/code]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources