27,579
社区成员
发帖
与我相关
我的任务
分享
create table material_table
(
M2PNO varchar(30)NOT NULL Primary Key,
design_size varchar(30)NULL,
tabulation_time varchar(30)NULL,
order_num varchar(30)NULL,
describe_good varchar(30)NULL,
)
go
表如下
create table sources_table
(
sources_price varchar(30) NULL,
sources_amount varchar(30) NULL,
sources_remarks varchar(30) NULL,
sources_factry varchar(30) NULL,
)
go
insert into t1 select * from t2
insert into t1 select t2.col , t3.col from t2,t3 where t2.id = t3.id
create table constracts_table
(
M2PNO varchar(30)NOT NULL Primary Key,
design_size varchar(30)NULL,
tabulation_time varchar(30)NULL,
order_num varchar(30)NULL,
size_num varchar(30)NULL,
describe_good varchar(30)NULL,
customer varchar(30)NULL,
produce_factory varchar(30)NULL,
)
go
create table sources_table
(
sources_name varchar(30) NOT NULL Primary Key,
sources_standard varchar(30) NULL,
sources_unit varchar(30) NULL,
sources_deplete varchar(30) NULL,
sources_price varchar(30) NULL,
sources_amount varchar(30) NULL,
sources_remarks varchar(30) NULL,
sources_factry varchar(30) NULL,
sources_colocr varchar(30) NULL,
sources_collocate varchar(30) NULL,
)
go
create table sources_table
(
sources_price varchar(30) NULL,
sources_amount varchar(30) NULL,
sources_remarks varchar(30) NULL,
sources_factry varchar(30) NULL,
)
go
create table sources_table
(
sources_collocate varchar(30) NULL,
)
go
create table sources_table
(
sources_color varchar(30) NULL,
sources_state varchar(30) NULL,
)
go