真爱无限的知识驿站

GO  

/****** 对象:  StoredProcedure [dbo].[pro_GenerateServiceFunction]    脚本日期: 08/04/2012 11:26:43 ******/  

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pro_GenerateServiceFunction]') AND type in (N'P', N'PC'))  

GO  

/****** 对象:  StoredProcedure [dbo].[pro_GenerateProGet]    脚本日期: 08/03/2012 11:26:43 ******/  

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pro_GenerateProGet]') AND type in (N'P', N'PC'))  

GO  

/****** 对象:  StoredProcedure [dbo].[pro_GenerateProSet]    脚本日期: 08/03/2012 11:26:43 ******/  

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pro_GenerateProSet]') AND type in (N'P', N'PC'))  

GO  

/****** 对象:  StoredProcedure [dbo].[pro_GenerateModel]    脚本日期: 08/04/2012 11:26:43 ******/  

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pro_GenerateModel]') AND type in (N'P', N'PC'))  

表数据：

-- 获取锁

ALTER procedure [dbo].[pro_get_sys_ordr_lock_info](   

     @ORDR_HEAD_SEQ 编号,  

     @ORDR_TYP_CD VARCHAR(20)  

 )as  

begin   

set ANSI_NULLS ON  

set QUOTED_IDENTIFIER ON  

go  

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

** PROCEDURE : pro_set_so_cust_info  

** DECRIPTION: 维护客户资料信息  

set ANSI_NULLS ON  

set QUOTED_IDENTIFIER ON  

go  

  

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

** PROCEDURE : pro_get_so_cust_list  

** DECRIPTION: 获取客户列表  

set ANSI_NULLS ON  

set QUOTED_IDENTIFIER ON  

go  

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

** PROCEDURE : pro_is_so_cust_nam_show_repeat  

** DECRIPTION: 判断客户用户和或显示名称是否重复  

select * from salaryinfo where datepart(yyyy,salarydate) =datepart(yyyy,GetDate()) and datepart(mm,salarydate)=datepart(mm,GetDate()) and datepart(dd,salarydate)=datepart(dd,GetDate())