Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
stored procedure execution show error
Devendra Kumar
Feb 17 2016 3:40 AM
310
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
HOW TO USE CASE---WHEN-----END IN SQL VIEW
Make SQL querys on view faster on c# and SQL server 2014