sql server插入where子句

问题描述

创建插入内容时的规则是

when creating a insert what is the rule

insert ps.pid, ps.tid, b.bpid into person p, pros ps, bid b
where p.pid = ps.pid
and p.bpid = b.bpid
and ps.pid = b.bpsid 

插入方向是否会按照专业ID插入人ID，然后将出价插入人，然后将投标插入人

或相反的

我有一个创建了ID号的数据列表.

优点是1到10
出价是1到10
人是1到10

出价表有很多优点
人员表具有优缺点的出价

我需要做的是当我为
插入内容时
人员表，它接收专业人士和出价fk id

so does the insert direction goes pros id insert into person id then bid insert into person then bid insert into pros

or the reverse

I have a list of data with id numbers created.

pros are 1 to 10
bid are 1 to 10
person are 1 to 10

the bid table has a fk of pros
the person table has a fk of pros and bid

what I need to happen is when I do a insert for the

person table that it receive the pros and the bid fk id

sample query would be nice.

推荐答案

这篇关于sql server插入where子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！