pwdencrypt-transact-sql.md

description	PWDENCRYPT (Transact-SQL)
title	PWDENCRYPT (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	reference
f1_keywords	PWDENCRYPT PWDENCRYPT_TSQL
dev_langs	TSQL
helpviewer_keywords	PWDENCRYPT function [Transact-SQL]
ms.assetid	333e9a43-1099-4b9b-b941-4b0b016f47f3
author	VanMSFT
ms.author	vanto

PWDENCRYPT (Transact-SQL)

[!INCLUDE SQL Server]

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

Syntax

PWDENCRYPT ( 'password' )  

[!INCLUDEsql-server-tsql-previous-offline-documentation]

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)