sql语句中的错误 [英] wrong in sql statement

问题描述

create proc [dbo].[InsertUser]
 (@AdvName nvarchar(50),@Addtype int,@Addgov int,@Addreg int,@AddFloor int,
@Addfinish int,@Addsalary int,@Addtel int)
 
 as insert into AdvertiseNames values
 
 (@AdvName,@Addtype,@Addreg,@AddFloor,@Addfinish,@Addsalary,@Addtel)
  insert into Regions values
 (@Addgov)

这是怎么回事plz ?????

what''s the wrong here plz?????

推荐答案

在不知道确切错误的情况下，我会猜测insert语句失败了，因为您没有没有列出目标列.试试类似的东西:

Without knowing the exact error you get I would guess that the insert statements are failing because you haven''t listed the target columns. Try something like:

create procedure [dbo].[InsertUser]
   (@AdvName nvarchar(50),
    @Addtype int,
    @Addgov int,
    @Addreg int,
    @AddFloor int,
    @Addfinish int,
    @Addsalary int,
    @Addtel int)
as 
begin
   insert into AdvertiseNames 
     (AdvName,Addtype,Addreg,AddFloor,Addfinish,Addsalary,Addtel) 
     values
     (@AdvName,@Addtype,@Addreg,@AddFloor,@Addfinish,@Addsalary,@Addtel);

   insert into Regions 
      (Addgov)
      values
      (@Addgov);
end;

列名纯属猜测，因为我不知道您的表结构.

The column names are pure guesses since I don''t know your table structure.

这篇关于sql语句中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！