/*
* 文件名：应变特征值存储过程.sql
* 说明：用来对桥梁应变的特征值进行操作
* 修改日期：2006.6.26
* 执行条件:当服务器操作系统重装或SQL Server2000系统重建时，才执行以下存储过程，否则不执行
*/
Use 小沟桥
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature0ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature0ByDateTime'))
Drop Procedure sp_DelYingBianFeature0ByDateTime
Go
Create Procedure sp_DelYingBianFeature0ByDateTime
(@CarTime char(14))
As
Delete From Section0 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature1ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature1ByDateTime'))
Drop Procedure sp_DelYingBianFeature1ByDateTime
Go
Create Procedure sp_DelYingBianFeature1ByDateTime
(@CarTime char(14))
As
Delete From Section1 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature2ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature2ByDateTime'))
Drop Procedure sp_DelYingBianFeature2ByDateTime
Go
Create Procedure sp_DelYingBianFeature2ByDateTime
(@CarTime char(14))
As
Delete From Section2 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature3ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature3ByDateTime'))
Drop Procedure sp_DelYingBianFeature3ByDateTime
Go
Create Procedure sp_DelYingBianFeature3ByDateTime
(@CarTime char(14))
As
Delete From Section3 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature4ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature4ByDateTime'))
Drop Procedure sp_DelYingBianFeature4ByDateTime
Go
Create Procedure sp_DelYingBianFeature4ByDateTime
(@CarTime char(14))
As
Delete From Section4 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature5ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature5ByDateTime'))
Drop Procedure sp_DelYingBianFeature5ByDateTime
Go
Create Procedure sp_DelYingBianFeature5ByDateTime
(@CarTime char(14))
As
Delete From Section5 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature6ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature6ByDateTime'))
Drop Procedure sp_DelYingBianFeature6ByDateTime
Go
Create Procedure sp_DelYingBianFeature6ByDateTime
(@CarTime char(14))
As
Delete From Section6 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature71ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeatur7ByDateTime'))
Drop Procedure sp_DelYingBianFeature7ByDateTime
Go
Create Procedure sp_DelYingBianFeature7ByDateTime
(@CarTime char(14))
As
Delete From Section7 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature8ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature8ByDateTime'))
Drop Procedure sp_DelYingBianFeatur8ByDateTime
Go
Create Procedure sp_DelYingBianFeature8ByDateTime
(@CarTime char(14))
As
Delete From Section8 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature9ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature9ByDateTime'))
Drop Procedure sp_DelYingBianFeature9ByDateTime
Go
Create Procedure sp_DelYingBianFeature9ByDateTime
(@CarTime char(14))
As
Delete From Section9 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature10ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature10ByDateTime'))
Drop Procedure sp_DelYingBianFeature10ByDateTime
Go
Create Procedure sp_DelYingBianFeature10ByDateTime
(@CarTime char(14))
As
Delete From Section10 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature11ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature11ByDateTime'))
Drop Procedure sp_DelYingBianFeature11ByDateTime
Go
Create Procedure sp_DelYingBianFeature11ByDateTime
(@CarTime char(14))
As
Delete From Section11 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature12ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature12ByDateTime'))
Drop Procedure sp_DelYingBianFeature12ByDateTime
Go
Create Procedure sp_DelYingBianFeature12ByDateTime
(@CarTime char(14))
As
Delete From Section12 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature13ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature13ByDateTime'))
Drop Procedure sp_DelYingBianFeature13ByDateTime
Go
Create Procedure sp_DelYingBianFeature13ByDateTime
(@CarTime char(14))
As
Delete From Section13 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature14ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature14ByDateTime'))
Drop Procedure sp_DelYingBianFeature14ByDateTime
Go
Create Procedure sp_DelYingBianFeature14ByDateTime
(@CarTime char(14))
As
Delete From Section14 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature15ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature15ByDateTime'))
Drop Procedure sp_DelYingBianFeature15ByDateTime
Go
Create Procedure sp_DelYingBianFeature15ByDateTime
(@CarTime char(14))
As
Delete From Section15 Where CarTime=@CarTime
Go
/*******************************************************************************************/
/*
* 存储过程名:sp_DelYingBianFeature16ByDateTime
* 功能说明：删除某一时间的桥梁应变特征值(幅值)
* 修改日期：2006.6.26
*/
/*******************************************************************************************/
If Exists(Select * From SysObjects Where id=Object_id('sp_DelYingBianFeature16ByDateTime'))
Drop Procedure sp_DelYingBianFeature16ByDateTime
Go
Create Procedure sp_DelYingBianFeature16ByDateTime
(@CarTime char(14))
As
Delete From Section16 Where CarTime=@CarTime
Go
/*******************************************************************************************/
