CREATE TRIGGER Insertion_Into_P
ON P
AFTER insert
AS
BEGIN
insert into P_Insertion values(pNo,pName,Color,weight)
select pNo,pName,Color,weight from insertedEND报错
消息 207,级别 16,状态 1,过程 Insertion_Into_P,第 7 行
列名 'pNo' 无效。
消息 207,级别 16,状态 1,过程 Insertion_Into_P,第 7 行
列名 'pName' 无效。
消息 207,级别 16,状态 1,过程 Insertion_Into_P,第 7 行
列名 'Color' 无效。
消息 207,级别 16,状态 1,过程 Insertion_Into_P,第 7 行
列名 'weight' 无效。P表和P_Insertion 表都是如下结构:
create table P(P_Insertion )
(
PNo char(2),
PName varchar(15),
Color char(2),
Weight int )到底哪里出问题了,急死了
ON P
AFTER insert
AS
BEGIN
insert into P_Insertion values(pNo,pName,Color,weight)
select pNo,pName,Color,weight from insertedEND报错
消息 207,级别 16,状态 1,过程 Insertion_Into_P,第 7 行
列名 'pNo' 无效。
消息 207,级别 16,状态 1,过程 Insertion_Into_P,第 7 行
列名 'pName' 无效。
消息 207,级别 16,状态 1,过程 Insertion_Into_P,第 7 行
列名 'Color' 无效。
消息 207,级别 16,状态 1,过程 Insertion_Into_P,第 7 行
列名 'weight' 无效。P表和P_Insertion 表都是如下结构:
create table P(P_Insertion )
(
PNo char(2),
PName varchar(15),
Color char(2),
Weight int )到底哪里出问题了,急死了
ON P
AFTER insert
AS
BEGINinsert into P_Insertion
select pNo,pName,Color,weight from insertedEND
(
PNo char(2),
PName varchar(15),
Color char(2),
Weight int )
create table P_Insertion
(
PNo char(2),
PName varchar(15),
Color char(2),
Weight int )
go
CREATE TRIGGER Insertion_Into_P
ON P
AFTER insert
AS
BEGINinsert into P_Insertion
select pNo,pName,Color,weight from inserted
END
go
insert into p select 'a1','abc','黑',15
go
select * from p_insertion
/*
PNo PName Color Weight
---- --------------- ----- -----------
a1 abc 黑 15(1 行受影响)*/
go
drop table p,p_insertion
CREATE TRIGGER Insertion_Into_P ON P
AFTER insert
AS
BEGINinsert into P_Insertion(pNo,pName,Color,weight)
select pNo,pName,Color,weight from insertedEND
基本的语句不过关那
ON P
AFTER insert
AS
BEGINinsert into P_Insertion(pNo,pName,Color,weight)
select pNo,pName,Color,weight from insertedEND
ON P
AFTER insert
AS
BEGINinsert into P_Insertion(pNo,pName,Color,weight)
select pNo,pName,Color,weight from insertedEND
INSERT INTO MyTable (PriKey, Description)
VALUES (123, 'A description of part 123.')用 SELECT 子查询为一行或多行指定数据值。
INSERT INTO MyTable (PriKey, Description)
SELECT ForeignKey, Description
FROM SomeView
事实上把insert into P_Insertion values(pNo,pName,Color,weight)
改成insert into P_Insertion (pNo,pName,Color,weight)后错误解决了,第一次在csdn发帖,多谢大家的鼎力相助!!