pwdencrypt-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
PWDENCRYPT (Transact-SQL)	PWDENCRYPT (Transact-SQL)	VanMSFT	vanto	03/14/2017	sql	t-sql	reference	PWDENCRYPT PWDENCRYPT_TSQL	PWDENCRYPT function [Transact-SQL]	TSQL

PWDENCRYPT (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

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.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

PWDENCRYPT ( 'password' )  

Arguments

password
Is the password to be encrypted. password is sysname.

Return Types

varbinary(128)

Permissions

PWDENCRYPT is available to public.

See Also

Security Functions (Transact-SQL)
PWDCOMPARE (Transact-SQL)