sql 语句
来源:互联网 发布:Js回车切换表单焦点 编辑:程序博客网 时间:2024/06/15 06:22
insert
into TransportExecution(ID,UnitID,Status,InitiateTime,ReceiveTime,MaterialStatus,Initiator,Receiver)
values(1,1,'运输中','2011-5-2','2011-5-2','完好','admin','admin')
-----------------------插入数据到TransportExecution
select * from TransportExecution
select F.status as 运输状态 ,A.Quantity as 数量,B.id as 所属运输计划编号,B.StartPos as 起始地点,B.Destination as 目的地,B.SendDepart as 发料单位,convert(varchar(10),B.requiredDate,120) as 需求日期,B.shift 班次,C.ID as 所属物料计划,C.MaterialName as 物料名称,C.Quantity as 需求数量,C.id as 所属物料计划编号,E.Creator as 条码生成人,convert(varchar(10),E.CreateTime,120) as 条码生成时间 from TransportPlan B,TransportUnit A,MaterialPlan C,Barcode as E ,TransportExecution as F where A.transportNo=B.id and A.transportNo=C.iD and E.Code=A.code and F.UnitID=A.ID and A.id=1
into TransportExecution(ID,UnitID,Status,InitiateTime,ReceiveTime,MaterialStatus,Initiator,Receiver)
values(1,1,'运输中','2011-5-2','2011-5-2','完好','admin','admin')
-----------------------插入数据到TransportExecution
select * from TransportExecution
select F.status as 运输状态 ,A.Quantity as 数量,B.id as 所属运输计划编号,B.StartPos as 起始地点,B.Destination as 目的地,B.SendDepart as 发料单位,convert(varchar(10),B.requiredDate,120) as 需求日期,B.shift 班次,C.ID as 所属物料计划,C.MaterialName as 物料名称,C.Quantity as 需求数量,C.id as 所属物料计划编号,E.Creator as 条码生成人,convert(varchar(10),E.CreateTime,120) as 条码生成时间 from TransportPlan B,TransportUnit A,MaterialPlan C,Barcode as E ,TransportExecution as F where A.transportNo=B.id and A.transportNo=C.iD and E.Code=A.code and F.UnitID=A.ID and A.id=1
- SQL语句
- sql语句
- SQL语句
- SQL语句
- SQL语句
- SQL语句
- SQL语句
- SQL语句
- SQL 语句
- sql语句
- sql语句
- Sql语句
- SQL语句
- SQL语句
- sql语句
- SQL 语句
- sql语句
- sql语句
- 秒杀多线程第五篇 经典线程同步 关键段CS
- DataTable分页实例,
- 第二章 IoC Bean的初始化与延迟加载
- AS3解析JSON
- Mtk6573使用虚拟机下载软件
- sql 语句
- socket连接服务端和客户端的新demo,扩展性更好,更适合用于项目中。
- Linux RAR 安装和使用
- 屏幕亮度设置
- MTKAndroid添加驱动模块
- Android Intent用法总结
- C++ Primer 习题 5.18 vector中存放指针
- 制造crash场景
- SVN文件库移植