CREATE trigger icstockbill_check --实现对物料单据管控 on Icstockbill for insert as Declare @Ftrantype int --单据类别定义/生产领料单24/调拔 单41/销售出库单21 Select @Ftrantype=Ftrantype from inserted --控制领料单的领料日期不能小于生产任务单的计划开工日期 倒扣物料只能车间仓库发料 if (@Ftrantype=24) begin declare @ic
传智播客传智播客省级数据库txt文件里面use SimpleArticle go --创建Province表 create table Province ( proID int primary key, proName nvarchar(50) not null ) -------------------------------------------------------------------------------------------------------------------
CREATE DATABASE itcast;创建数据库
SHOW DATABASES;查看数据库
SHOW CREATE DATABASE itcast;查看创建的数据库
ALTER DATABASE itcast DEFAULT CHARACTER SET utf8;修改
DROP DATABASE itcast;删除数据库
定时事件:
DELIMITER $$
ALTER DEFINER=`root``%` EVENT `NewEvent` ON SCHEDULE EVERY 30 SECOND STARTS '2018-10-08 14:00:00' ON COMPLETION NOT PRESERVE ENABLE DO CALL update_a()$$
DELIMITER ;
储存过程随机数:
DELIMITER $$
USE `figure`$$
Sky Master ULTIMATE,动态天空+天气+云+海洋系统源码
Sky Master is a Dynamic Sky, Weather, Volumetric Cloud - Lighting, Dynamic GI & Ocean solution for Unity.
The system includes one draw call Volume Clouds, an Ocean system, GI Proxy for Global Illumination & a phy
<%
function ReadFile(filename)
on error resume next
err.clear
‘ASP的一种校错方法
Const ForReading = 2
Const Create = false
Dim FSO
DIM TS
DIM filepath
DIM thefile
Dim content
‘—————操作地址
Set FSO=server.createobject(scr ipting.filesystemobject)
filepath