应变特征值存储过程.sql

大型桥梁健康监测中的关于数据库的存储过程的实现

/*
 *	文件名：应变特征值存储过程.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

/*******************************************************************************************/