/*
* 文件名:左右副桥特征值的存储过程.sql
* 说明:用来对桥梁的特征值进行操作
* 修改日期:2006.6.22
* 执行条件:当服务器操作系统重装或SQL Server2000系统重建时,才执行以下存储过程,否则不执行
*/
Use 小沟桥
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelLeftFeatureByDateTime
* 功能说明:删除某一时间的左幅桥特征值(幅值)
* 修改日期:2006.6.23
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelLeftFeatureByDateTime'))
Drop Procedure sp_DelLeftFeatureByDateTime
Go
Create Procedure sp_DelLeftFeatureByDateTime
@CarTime char(14)
As
Delete From LeftFeature Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelRightFeatureByDateTime
* 功能说明:删除某一时间的右幅桥特征值(幅值)
* 修改日期:2006.6.22
*/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelRightFeatureByDateTime'))
Drop Procedure sp_DelRightFeatureByDateTime
Go
Create Procedure sp_DelRightFeatureByDateTime
@CarTime char(14)
As
Delete From RightFeature Where CarTime=@CarTime
Go
/*******************************************************************************************/