panankx123
03-31-2011, 12:37 PM
--以下语句创建一个非对称密钥asymDemoKeyuse DB_Encrypt_DemogoCREATE ASYMMETRIC Primary asymDemoKey --创建非对称密钥名称WITH ALGORITHM = RSA_512 --加密安全类型ENCRYPTION BY PASSWORD = 'TestASYM123,Microsoft Office 2007 Ultimate Product Key (http://www.office2007-key.eu/)!' --密码--查看当前数据库中的非对称密钥use DB_Encrypt_DemogoSELECT title,Microsoft Office Pro Plus 2007 Serial (http://www.office-2007-key.de/), algorithm_desc,Office 2010 32bit Key (http://www.office2010-key.ca/), pvt_key_encryption_type_descFROM sys.asymmetric_keys----结果返回/*name algorithm_desc pvt_key_encryption_type_descasymDemoKey RSA_512 ENCRYPTED_BY_PASSWORD*/