Synear_API/sql/sql_20180511...

/****** Object:  StoredProcedure [dbo].[proc_HR_ZZBDH]    Script Date: 05/15/2018 09:52:07 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[proc_HR_ZZBDH]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[proc_HR_ZZBDH]
GO

/****** Object:  StoredProcedure [dbo].[proc_HR_ZZBDH]    Script Date: 05/15/2018 09:52:07 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


------------------------------------
--ÓÃ;£º×ªÖµ°àµç»°
------------------------------------
CREATE PROCEDURE [dbo].[proc_HR_ZZBDH]

 AS
 declare @zbdh varchar(50)
select top 1 @zbdh=F_ParamValue from T_Sys_SystemConfig where F_ParamCode='zbdh'

select @zbdh


GO