USE [customcontrolsetting]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_all_task]
@table_name nvarchar(max),
@taction nvarchar(max),
@tcolumn nvarchar(max),
@tvalues nvarchar(max),
@tconditions nvarchar(max)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @cmd AS NVARCHAR(max)
if(@taction = 'insert')
SET @cmd='insert into '+@table_name+' ('+@tcolumn+') values('+@tvalues+') '
EXEC sp_all_task @cmd
END
this is my query in store procedure ...
EXEC [sp_all_task] @table_name='AA',@taction='insert', @tcolumn='CC',@tvalues='DD',@tconditions='EE'
when i execute this folowing error is occured
error
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 201, Level 16, State 4, Procedure sp_all_task, Line 0
Procedure or function 'sp_all_task' expects parameter '@taction', which was not supplied.
Msg 217, Level 16, State 1, Procedure sp_all_task, Line 20
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).