Devendra  Kumar

Devendra Kumar

  • NA
  • 517
  • 233.9k

stored procedure execution show error

Feb 17 2016 3:40 AM
Create PROCEDURE [dbo].[Sp_BannerOpeartions]
@BannerOperationName varchar(100),
@BannerId int,
@BannerImage varchar(250),
@BannerOrderNumber int
AS
BEGIN
if(@BannerOperationName='Select')
begin
Select * from dbo.Tbl_Banner order by BannerOrderNumber
end
if(@BannerOperationName='Insert')
begin
Insert into dbo.Tbl_Banner values (@BannerImage,@BannerOrderNumber)
end
 
 
error msg ;;
 
Msg 213, Level 16, State 1, Procedure Sp_BannerOpeartions, Line 21
Column name or number of supplied values does not match table definition.
 

Answers (4)