我的存储过程给出错误 [英] My Stored Procedure Gives error

问题描述

CREATE PROCEDURE empinsert
	@email varchar(50),
	@Name varchar(50),
	@FatherName varchar(50),
	@Login varchar(50),
	@Password varchar(50),
	@Department Varchar(50),
	@Designation varchar(50),
	@weightage int
	As
	
	Begin 
	insert into emp_registration values(@email,@Name,@FatherName,@Login,@Password,@Department,@Designation)
	END
	
				if @Designation ='Manager'
                
                    @weightage = 7;
                
              else if @Designation = 'Asst.Manager'
                
                    @weightage = 5;
                
                else if @Designation= 'Deputy Manager'
                                    
                    @weightage = 6;
                
               else if @Designation = 'Team Leader'
               
                   @weightage = 4;
               
 
              else if @Designation = 'Executives'
                
                    @weightage= 3;
                
                else if @Designation = 'Clerk'
                
                    @weightage = 3;
                
 
               else if @Designation= "Officeassistant"
                
                    @weightage = 2;
                
	Begin				
	insert into Users values(@Login,@Password,@weightage)
	End
	Go

推荐答案

您过早插入了 end

You have inserted end too early

As

Begin
insert into emp_registration values(@email,@Name,@FatherName,@Login,@Password,@Department,@Designation)
END

if @Designation ='Manager'

好的..



除了Vyacheslav上面所说的，这不是C＃而且之后不应该有分号 @weightage = 4;



希望有所帮助

Milind

Well wel..

Besides what Vyacheslav said above, this is not C# and there should not be a "semi-colon" after @weightage = 4;

Hope that helps
Milind

以及解决方案1& 2，你还有一些其他语法错误：

它应该是什么样子

Along with what was described in Solutions 1 & 2, you also have some other syntax errors:
This is what it should look like

CREATE PROCEDURE empinsert
   @email varchar(50),
   @Name varchar(50),
   @FatherName varchar(50),
   @Login varchar(50),
   @Password varchar(50),
   @Department Varchar(50),
   @Designation varchar(50),
   @weightage int
   As
   Begin 

   insert into emp_registration values(@email,@Name,@FatherName,@Login,@Password,@Department,@Designation)
   END 

   if @Designation ='Manager'
      SET @weightage = 7
   else if @Designation = 'Asst.Manager'
      SET @weightage = 5
   else if @Designation= 'Deputy Manager'
      SET @weightage = 6
   else if @Designation = 'Team Leader'
      SET @weightage = 4
   else if @Designation = 'Executives'
      SET @weightage= 3                
   else if @Designation = 'Clerk'
      SET @weightage = 3                 
   else if @Designation= "Officeassistant"                
      SET @weightage = 2

   BEGIN
   insert into Users values(@Login,@Password,@weightage)
End
Go

这篇关于我的存储过程给出错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！