| title | PWDENCRYPT (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 333e9a43-1099-4b9b-b941-4b0b016f47f3 | ||
| caps.latest.revision | 9 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Returns the [!INCLUDEssNoVersion] password hash of the input value that uses the current version of the password hashing algorithm.
PWDENCRYPT is an older function and might not be supported in a future release of [!INCLUDEssNoVersion]. Use HASHBYTES instead. HASHBYTES provides more hashing algorithms.
Transact-SQL Syntax Conventions
PWDENCRYPT ( 'password' )
password
Is the password to be encrypted. password is sysname.
varbinary(128)
PWDENCRYPT is available to public.