create trigger add_ciry on phx_customers
instead of insert
as declare
@fname varchar(20),
@lname varchar(20),
@addr varchar(50),
@city varchar(20),
@state char(2),
@zip char(5),
@phone char(10)-----------------,set @city = 'phoenix'
set @fname = (select fname from insterted)
set @lname = (select fname from insterted)
set @addr = (select fname from insterted)
set @state = (select fname from insterted)
set @zip = (select fname from insterted)
set @phone = (select fname from insterted)
insert customers
values(@fname,@lname,@addr,@city,@state,@zip,@phone)
instead of insert
as declare
@fname varchar(20),
@lname varchar(20),
@addr varchar(50),
@city varchar(20),
@state char(2),
@zip char(5),
@phone char(10)-----------------,set @city = 'phoenix'
set @fname = (select fname from insterted)
set @lname = (select fname from insterted)
set @addr = (select fname from insterted)
set @state = (select fname from insterted)
set @zip = (select fname from insterted)
set @phone = (select fname from insterted)
insert customers
values(@fname,@lname,@addr,@city,@state,@zip,@phone)
@lname varchar(20),
@addr varchar(50),
@city varchar(20),
@state char(2),
@zip char(5),
@phone char(10),
沒 “,”
后面的‘逗号’不要
改为:
select @fname=fname from insterted
@fname varchar(20),
@lname varchar(20),
@addr varchar(50),
@city varchar(20),
@state char(2),
@zip char(5),
@phone char(10) “,“
这个逗号肯定有错!
若插入多行则出错,应用游标逐行读