Hi everybody,
I wrote following stored procedure using dynamic sql..It throws error like the parameterized query '(@R1 NVARCHAR(20),@R2 nvarchar(20),@R3 date,@R4 datetime,@R5 flo' expects the parameter '@R19', which was not supplied.
The sp is as follows:
ALTER PROCEDURE [dbo].[Usp_InsertGPSDataSample]
-- Add the parameters for the stored procedure here
@ime_Number NVARCHAR(20)
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
DECLARE @execquery AS NVARCHAR(MAX),
@tablename AS NVARCHAR(20),
@result AS INT
SET @tablename=@ime_Number
SET @execquery='INSERT INTO '+@tablename+' (Device_status,Device_Date,Device_Time,Latitude,Longitude,Distance,Altitude,Angle,Speed,Ignition,Io2,Io3,Io4,Fuel,Analog_data,Serial_data,Mode,Movement)'
SET @execquery=@execquery+'VALUES(@R1,@R2,@R3,@R4,@R5,@R6,@R7,@R8,@R9,@R10,@R11,@R12,@R13,@R14,@R15,@R16,@R17,@R18,@R19)'
EXEC @result=sp_executesql @execquery,N'@R1 NVARCHAR(20),@R2 nvarchar(20),@R3 date,@R4 datetime,@R5 float,@R6 float,@R7 float,@R8 float,@R9 float,
@R10 float,@R11 int,@R12 int,@R13 int,@R14 int,@R15 float,@R16 float,@R17 float,@R18 int,@R19 int',
'@A','2014-01-24','10:06:38',68.545,46.879,78,454,6,4,7,3,6,1,1,75,22,3,-1
RETURN @result
END TRY
BEGIN CATCH
SELECT ERROR_MESSAGE() AS ErrMsg, ERROR_LINE() AS ErrLine,ERROR_PROCEDURE() AS ErrProc
END CATCH
END
Any help will be appreciated!!!
THANK YOU