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