Stored Procedure(存储过程)编写经验和优化措施
2007-11-11 08:01:05 来源:WEB开发网核心提示: >>加密From the Books Online: Use the W99vH ENCRYPTION option: IF EXISTS (SELECT name FROM sysobjects
>>加密
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
[]
更多精彩
赞助商链接