新手请教存储过程

Question

CREATE PROC Pro_Insert
(
 @Oper_user char(10),
 @Oper_password char(10),
 @Oper_level char(10)
)
as
declare  @Oper_id int
set  @Oper_id = (select count(*) from Oper where Oper_user=@Oper_user)
if @Oper_id <> 0
 begin
   print 'An error occurred loading the new lines'
   return
 end
else
 begin
   insert into Oper(Oper_user,Oper_password,Oper_level) values (@Oper_user,@Oper_password,@Oper_level)
   print 'Successful'
   return
 end
Go

Answer 1

CREATE PROC Pro_Insert
 
 @Oper_user char(10),
 @Oper_password char(10),
 @Oper_level char(10)
as                      --少了as
declare  @Oper_id int
select  @Oper_id = (select count(*) from Oper where Oper_user=@Oper_user)
if @Oper_id <> 0
 begin
   print 'An error occurred loading the new lines'
   return
 end
else
 begin
   insert into Oper(Oper_user,Oper_password,Oper_level) values (@Oper_user,@Oper_password,@Oper_level)
   print 'Successful'
   return
 end
Go

Answer 2

CREATE PROC Pro_Insert
 @Oper_user     char(10),
 @Oper_password char(10),
 @Oper_level    char(10)
AS
BEGIN
    declare @Oper_id int
    select @Oper_id=count(*) from Oper where Oper_user=@Oper_user
    if @Oper_id <> 0
    begin
        print 'An error occurred loading the new lines'
        return
    end
    else
    begin
        insert into Oper(Oper_user,Oper_password,Oper_level) values (@Oper_user,@Oper_password,@Oper_level)
        print 'Successful'
        return
    end
END
GO

Answer 3

CREATE PROC Pro_Insert
 @Oper_user     char(10),
 @Oper_password char(10),
 @Oper_level    char(10)
AS
BEGIN
    declare @Oper_id int
    select @Oper_id=count(*) from Oper where Oper_user=@Oper_user
    if @Oper_id <> 0
    begin
        print 'An error occurred loading the new lines'
        return
    end
    else
    begin
        insert into Oper(Oper_user,Oper_password,Oper_level) values (@Oper_user,@Oper_password,@Oper_level)
        print 'Successful'
        return
    end
END
GO

Answer 4

或者修改成这样：
------------------------------------------------------------
CREATE PROC Pro_Insert
 @Oper_user     char(10),
 @Oper_password char(10),
 @Oper_level    char(10)
AS
BEGIN
    IF EXISTS(SELECT 1 FROM oper WHERE Oper_user=@Oper_user)
    BEGIN
        print 'An error occurred loading the new lines'
    END
    ELSE
    BEGIN
        insert into Oper(Oper_user,Oper_password,Oper_level) values (@Oper_user,@Oper_password,@Oper_level)
        print 'Successful'
    END
END
GO

Answer 5

这样做试试：
CREATE PROC Pro_Insert
 
 @Oper_user char(10),
 @Oper_password char(10),
 @Oper_level char(10)
AS                         
if exists(select*from Oper where Oper_user=@Oper_user)
 begin
   print 'An error occurred loading the new lines'
   return
 end
else
 begin
   insert into Oper(Oper_user,Oper_password,Oper_level) values    (@Oper_user,@Oper_password,@Oper_level)
   print 'Successful'
   return
 end
Go

Answer 6

CREATE PROC Pro_Insert
 
 @Oper_user char(10),
 @Oper_password char(10),
 @Oper_level char(10)
as 
declare  @Oper_id int
if exists(select * from Oper where Oper_user=@Oper_user)
 begin
   print 'An error occurred loading the new lines'
   return
 end
else
 begin
   insert into Oper(Oper_user,Oper_password,Oper_level) 
   values (@Oper_user,@Oper_password,@Oper_level)
   print 'Successful'
   return
 end