How To execute stored proc.with Tablename,Fields supplying Run Time - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

How To execute stored proc.with Tablename,Fields supplying Run Time

Hi every one ...

while executing a stored procedure named 'Sp1',i m getting following error:

'The name "XYZ" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.'

...................
set ANSI_NULLS OFF
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Sp1]
@mTableName varchar(255),
@mFieldList varchar(255),
@mValueList varChar(255)
AS
Declare @Str varchar(255)
SET NOCOUNT ON
select @Str='INSERT INTO'+@mTableName+'('+@mFieldList+')'+'Values' +'('+@mValueList+')'
exec(@Str)
SET NOCOUNT OFF
.................

execute statment is as follows:
execute Sp1 tblEmployee , Name , 'XYZ'


Can Anyone Help me Out
Sign In or Register to comment.