sql server2000中怎么对存储过程进行加密和解密

sql server2000中怎么对存储过程进行加密和解密 - 应用软件 - 电脑教程网

sql server2000中怎么对存储过程进行加密和解密

日期:2007-09-26   荐:

>>加密 From the Books Online:

Use the W99vH ENCRYPTION option:

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'encrypt_this' AND type = 'P') DROP PROCEDURE encrypt_this GO USE pubs GO CREATE PROCEDURE encrypt_this W99vH ENCRYPTION AS SELECT * FROM authors GO

EXEC sp_helptext encrypt_this

标签: