Msg 8144, Level 16, State 2, Procedure INSERT_Thing, Line 0 Procedure or function INSERT_Thing has too many arguments specified.
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo
ALTER PROCEDURE [dbo].[INSERT_Thing]
@BG_L3_NAME varchar(50),
@BG_PREFERENCE numeric,
@BG_TEXT1 varchar(100),
@BG_TEXT2 varchar(100),
@BG_TEXT3 varchar(100),
@BG_TEXT4 varchar(100),
@BG_TEXT5 varchar(100),
@BG_TEXT6 varchar(100),
@BG_TEXT7 varchar(100),
@BG_TEXT8 varchar(100),
@BG_TEXT9 varchar(100),
@BG_TEXT10 varchar(100),
@BG_TEXT11 varchar(100),
@BG_TEXT12 varchar(100),
@BG_TEXT13 varchar(100),
@BG_IMAGE1 varchar(100),
@BG_USERNAME varchar(50),
@BG_IMAGE varchar(100)
AS
IF EXISTS(SELECT * FROM Thing WHERE BG_L3_NAME=@BG_L3_NAME)
BEGIN
PRINT 'FOUND'
SELECT @BG_PREFERENCE = (SELECT MAX(BG_PREFERENCE) FROM Thing WHERE BG_L3_NAME=@BG_L3_NAME)
SET @BG_PREFERENCE = @BG_PREFERENCE + 1 PRINT @BG_PREFERENCE
END
ELSE
BEGIN
PRINT 'NOT FOUND'
SET @BG_PREFERENCE = 1
END
INSERT Thing(BG_L3_NAME,BG_PREFERENCE,BG_TEXT1,BG_TEXT2,BG_TEXT3,BG_TEXT4,BG_TEXT5,BG_TEXT6,BG_TEXT7,BG_TEXT8,BG_TEXT9,BG_TEXT10,BG_TEXT11,BG_TEXT12,BG_TEXT13,BG_IMAGE1,BG_USERNAME,BG_IMAGE)
VALUES(@BG_L3_NAME,@BG_PREFERENCE,@BG_TEXT1,@BG_TEXT2,@BG_TEXT3,@BG_TEXT4,@BG_TEXT5,@BG_TEXT6,@BG_TEXT7,@BG_TEXT8,@BG_TEXT9,@BG_TEXT10,@BG_TEXT11,@BG_TEXT12,@BG_TEXT13,@BG_IMAGE1,@BG_USERNAME,@BG_IMAGE)
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
EXEC INSERT_Thing 'thing','0','','#1','11','22','33','44','55','66','77','88','99','00','11S','2SS','Folder/swatantra.jpg','127.0.0.1','swatantra.jpg'
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''