SQL SERVER数据库存储过程加密

 

 

CREATE PROCEDURE [dbo].[kytj_Base_Worker]
WITH ENCRYPTION
AS
 SELECT
        u.worker_number,
        u.worker_name,
        CONVERT(VARCHAR(8), u.Worker_qcrq, 112) Worker_qcrq,
        B.Key_name AS Worker_zhxlName,
        D.Key_name AS worker_zcName ,
        A.Key_number AS Worker_xzzwName,
        C.Key_name AS Worker_xk1Name,u.Worker_sfzz
FROM [dbo].[Base_Worker] u
    LEFT OUTER JOIN dbo.base_dbkey AS B ON u.Worker_zhxl = B.Key_number
    LEFT OUTER JOIN dbo.base_dbkey AS C ON u.Worker_xk1 = C.Key_number
    LEFT OUTER JOIN dbo.base_dbkey AS D ON u.worker_zc = D.Key_number
    LEFT OUTER JOIN dbo.base_dbkey AS A ON u.Worker_xzzw = D.Key_number

GO