SQL Server
Italia (Italiano) Accedi
Home 2012 2008 R2 2008 Versioni precedenti Libreria Forum
Libreria TechNet
SQL Server
SQL Server 2008
Documentazione sul prodotto
Documentazione online di SQL Server 2008
Motore di database
Riferimento tecnico
Guida di riferimento a Transact-SQL
Convenzioni della sintassi Transact-SQL (Transact-SQL)
Esercitazione: Scrittura di istruzioni Transact-SQL
+ (addizione) (Transact-SQL)
+ (operatore più unario) (Transact-SQL)
+ (concatenazione di stringhe) (Transact-SQL)
+= (Add EQUALS) (Transact-SQL)
+= (concatenazione di stringhe) (Transact-SQL)
- (negativo) (Transact-SQL)
- (sottrazione) (Transact-SQL)
-= (Subtract EQUALS) (Transact-SQL)
* (moltiplicazione) (Transact-SQL)
*= (Multiply EQUALS) (Transact-SQL)
/ (divisione) (Transact-SQL)
/= (Divide EQUALS) (Transact-SQL)
\ (barra rovesciata) (Transact-SQL)
% (modulo) (Transact-SQL)
%= (Modulo EQUALS) (Transact-SQL)
% (carattere jolly) (Transact-SQL)
& (AND bit per bit) (Transact-SQL)
&= (AND EQUALS bit per bit) (Transact-SQL)
| (OR bit per bit) (Transact-SQL)
|= (OR EQUALS bit per bit) (Transact-SQL)
^ (OR esclusivo bit per bit) (Transact-SQL)
^= (OR EQUALS esclusivo bit per bit) (Transact-SQL)
~ (NOT bit per bit) (Transact-SQL)
= (uguale a) (Transact-SQL)
> (maggiore di) (Transact-SQL)
< (minore di) (Transact-SQL)
>= (maggiore o uguale a) (Transact-SQL)
<= (minore o uguale a) (Transact-SQL)
<> (diverso da) (Transact-SQL)
!< (maggiore o uguale a) (Transact-SQL)
!= (diverso da) (Transact-SQL)
!> (non maggiore di) (Transact-SQL)
-- (commento) (Transact-SQL)
/*...*/ (commento) (Transact-SQL)
[ ] (carattere jolly) (Transact-SQL)
[^] (carattere jolly) (Transact-SQL)
_ (carattere jolly per corrispondenze di singoli caratteri) (Transact-SQL)
$PARTITION (Transact-SQL)
@@CONNECTIONS (Transact-SQL)
@@CPU_BUSY (Transact-SQL)
@@CURSOR_ROWS (Transact-SQL)
@@DATEFIRST (Transact-SQL)
@@DBTS (Transact-SQL)
@@ERROR (Transact-SQL)
@@FETCH_STATUS (Transact-SQL)
@@IDENTITY (Transact-SQL)
@@IDLE (Transact-SQL)
@@IO_BUSY (Transact-SQL)
@@LANGID (Transact-SQL)
@@LANGUAGE (Transact-SQL)
@@LOCK_TIMEOUT (Transact-SQL)
@@MAX_CONNECTIONS (Transact-SQL)
@@MAX_PRECISION (Transact-SQL)
@@NESTLEVEL (Transact-SQL)
@@OPTIONS (Transact-SQL)
@@PACK_RECEIVED (Transact-SQL)
@@PACK_SENT (Transact-SQL)
@@PACKET_ERRORS (Transact-SQL)
@@PROCID (Transact-SQL)
@@REMSERVER (Transact-SQL)
@@ROWCOUNT (Transact-SQL)
@@SERVERNAME (Transact-SQL)
@@SERVICENAME (Transact-SQL)
@@SPID (Transact-SQL)
@@TEXTSIZE (Transact-SQL)
@@TIMETICKS (Transact-SQL)
@@TOTAL_ERRORS (Transact-SQL)
@@TOTAL_READ (Transact-SQL)
@@TOTAL_WRITE (Transact-SQL)
@@TRANCOUNT (Transact-SQL)
@@VERSION (Transact-SQL)
ABS (Transact-SQL)
ACOS (Transact-SQL)
ADD SIGNATURE (Transact-SQL)
ALL (Transact-SQL)
Istruzioni ALTER (Transact-SQL)
AND (Transact-SQL)
ANY (Transact-SQL)
APPLOCK_MODE (Transact-SQL)
APPLOCK_TEST (Transact-SQL)
APP_NAME (Transact-SQL)
ASCII (Transact-SQL)
ASIN (Transact-SQL)
ASSEMBLYPROPERTY (Transact-SQL)
ASYMKEY_ID (Transact-SQL)
ASYMKEYPROPERTY (Transact-SQL)
ATAN (Transact-SQL)
ATN2 (Transact-SQL)
AVG (Transact-SQL)
BACKUP (Transact-SQL)
BACKUP CERTIFICATE (Transact-SQL)
BACKUP MASTER KEY (Transact-SQL)
BACKUP SERVICE MASTER KEY (Transact-SQL)
BEGIN...END (Transact-SQL)
BEGIN CONVERSATION TIMER (Transact-SQL)
BEGIN DIALOG CONVERSATION (Transact-SQL)
BEGIN DISTRIBUTED TRANSACTION (Transact-SQL)
BEGIN TRANSACTION (Transact-SQL)
BETWEEN (Transact-SQL)
binary e varbinary (Transact-SQL)
BINARY_CHECKSUM (Transact-SQL)
bit (Transact-SQL)
BREAK (Transact-SQL)
BULK INSERT (Transact-SQL)
CASE (Transact-SQL)
CAST e CONVERT (Transact-SQL)
CATCH (TRY...CATCH) (Transact-SQL)
CEILING (Transact-SQL)
CertProperty (Transact-SQL)
Cert_ID (Transact-SQL)
Funzioni Change Data Capture (Transact-SQL)
Funzioni di rilevamento delle modifiche (Transact-SQL)
char and varchar (Transact-SQL)
CHAR (Transact-SQL)
CHARINDEX (Transact-SQL)
CHECKPOINT (Transact-SQL)
CHECKSUM (Transact-SQL)
CHECKSUM_AGG
CLOSE (Transact-SQL)
CLOSE MASTER KEY (Transact-SQL)
CLOSE SYMMETRIC KEY (Transact-SQL)
COALESCE (Transact-SQL)
COLLATE (Transact-SQL)
COLLATIONPROPERTY (Transact-SQL)
COL_LENGTH (Transact-SQL)
COL_NAME (Transact-SQL)
COLUMNPROPERTY (Transact-SQL)
COLUMNS_UPDATED (Transact-SQL)
COMMIT TRANSACTION (Transact-SQL)
COMMIT WORK (Transact-SQL)
Operatori composti (Transact-SQL)
COMPUTE (Transact-SQL)
CONNECTIONPROPERTY (Transact-SQL)
Costanti (Transact-SQL)
CONTAINS (Transact-SQL)
CONTAINSTABLE (Transact-SQL)
CONTINUE (Transact-SQL)
CONTEXT_INFO (Transact-SQL)
Elementi del linguaggio per il controllo di flusso (Transact-SQL)
CONVERT (Transact-SQL)
COS (Transact-SQL)
COT (Transact-SQL)
COUNT (Transact-SQL)
COUNT_BIG (Transact-SQL)
Istruzioni CREATE (Transact-SQL)
CRYPT_GEN_RANDOM (Transact-SQL)
CURRENT_REQUEST_ID (Transact-SQL)
CURRENT_TIMESTAMP (Transact-SQL)
CURRENT_USER (Transact-SQL)
cursor (Transact-SQL)
CURSOR_STATUS (Transact-SQL)
Cursori (Transact-SQL)
Funzioni dell'agente di raccolta dati (Transact-SQL)
Tipi di dati (Transact-SQL)
DATABASE_PRINCIPAL_ID (Transact-SQL)
DATABASEPROPERTY (Transact-SQL)
DATABASEPROPERTYEX (Transact-SQL)
DATALENGTH (Transact-SQL)
date (Transact-SQL)
DATEADD (Transact-SQL)
DATEDIFF (Transact-SQL)
DATENAME (Transact-SQL)
DATEPART (Transact-SQL)
datetime (Transact-SQL)
datetime2 (Transact-SQL)
datetimeoffset (Transact-SQL)
DAY (Transact-SQL)
DB_ID (Transact-SQL)
DB_NAME (Transact-SQL)
DBCC (Transact-SQL)
DEALLOCATE (Transact-SQL)
decimal e numeric (Transact-SQL)
DECLARE @local_variable (Transact-SQL)
DECLARE CURSOR (Transact-SQL)
DECRYPTBYASYMKEY (Transact-SQL)
DECRYPTBYCERT (Transact-SQL)
DECRYPTBYKEY (Transact-SQL)
DECRYPTBYKEYAUTOASYMKEY (Transact-SQL)
DECRYPTBYKEYAUTOCERT (Transact-SQL)
DECRYPTBYPASSPHRASE (Transact-SQL)
DEGREES (Transact-SQL)
DELETE (Transact-SQL)
DENSE_RANK (Transact-SQL)
DENY (Transact-SQL)
DIFFERENCE (Transact-SQL)
DISABLE TRIGGER (Transact-SQL)
Istruzioni DROP (Transact-SQL)
ELSE (IF...ELSE) (Transact-SQL)
ENABLE TRIGGER (Transact-SQL)
ENCRYPTBYASYMKEY (Transact-SQL)
ENCRYPTBYCERT (Transact-SQL)
ENCRYPTBYKEY (Transact-SQL)
ENCRYPTBYPASSPHRASE (Transact-SQL)
END (BEGIN...END) (Transact-SQL)
END CONVERSATION (Transact-SQL)
ERROR_LINE (Transact-SQL)
ERROR_MESSAGE (Transact-SQL)
ERROR_NUMBER (Transact-SQL)
ERROR_PROCEDURE (Transact-SQL)
ERROR_SEVERITY (Transact-SQL)
ERROR_STATE (Transact-SQL)
EVENTDATA (Transact-SQL)
EXCEPT e INTERSECT (Transact-SQL)
EXECUTE AS (Transact-SQL)
Clausola EXECUTE AS (Transact-SQL)
EXECUTE
EXISTS (Transact-SQL)
EXP (Transact-SQL)
Espressioni (Transact-SQL)
FETCH (Transact-SQL)
FILE_ID (Transact-SQL)
FILE_IDEX (Transact-SQL)
FILE_NAME (Transact-SQL)
FILEGROUP_ID (Transact-SQL)
FILEGROUP_NAME (Transact-SQL)
FILEGROUPPROPERTY (Transact-SQL)
FILEPROPERTY (Transact-SQL)
float e real (Transact-SQL)
FLOOR (Transact-SQL)
sys.fn_check_object_signatures (Transact-SQL)
fn_get_audit_file (Transact-SQL)
fn_get_sql (Transact-SQL)
fn_helpcollations (Transact-SQL)
fn_listextendedproperty (Transact-SQL)
sys.fn_xe_file_target_read_file (Transact-SQL)
fn_my_permissions (Transact-SQL)
fn_servershareddrives (Transact-SQL)
fn_trace_geteventinfo (Transact-SQL)
fn_trace_getfilterinfo (Transact-SQL)
fn_trace_getinfo (Transact-SQL)
fn_trace_gettable (Transact-SQL)
fn_virtualfilestats (Transact-SQL)
fn_virtualservernodes (Transact-SQL)
Clausola FOR (Transact-SQL)
FORMATMESSAGE (Transact-SQL)
FREETEXT (Transact-SQL)
FREETEXTTABLE (Transact-SQL)
FROM (Transact-SQL)
FULLTEXTCATALOGPROPERTY (Transact-SQL)
FULLTEXTSERVICEPROPERTY (Transact-SQL)
Funzioni (Transact-SQL)
geography (Transact-SQL)
geometry (Transact-SQL)
GET CONVERSATION GROUP (Transact-SQL)
GET_FILESTREAM_TRANSACTION_CONTEXT (Transact-SQL)
GET_TRANSMISSION_STATUS (Transact-SQL)
GETANSINULL (Transact-SQL)
GETDATE (Transact-SQL)
GETUTCDATE (Transact-SQL)
GO (Transact-SQL)
GOTO (Transact-SQL)
GRANT (Transact-SQL)
GROUP BY (Transact-SQL)
GROUPING (Transact-SQL)
GROUPING_ID (Transact-SQL)
HAS_DBACCESS (Transact-SQL)
HAS_PERMS_BY_NAME (Transact-SQL)
HashBytes (Transact-SQL)
HAVING (Transact-SQL)
hierarchyid (Transact-SQL)
Hint (Transact-SQL)
HOST_ID (Transact-SQL)
HOST_NAME (Transact-SQL)
IDENT_CURRENT (Transact-SQL)
IDENT_INCR (Transact-SQL)
IDENT_SEED (Transact-SQL)
IDENTITY (funzione) (Transact-SQL)
IDENTITY (proprietà) (Transact-SQL)
IF...ELSE (Transact-SQL)
image (Transact-SQL)
IN (Transact-SQL)
INDEXKEY_PROPERTY (Transact-SQL)
INDEXPROPERTY (Transact-SQL)
INDEX_COL (Transact-SQL)
INSERT (Transact-SQL)
int, bigint, smallint e tinyint (Transact-SQL)
Clausola INTO (Transact-SQL)
IS_MEMBER (Transact-SQL)
IS_OBJECTSIGNED (Transact-SQL)
IS_SRVROLEMEMBER (Transact-SQL)
ISDATE (Transact-SQL)
IS [NOT] NULL (Transact-SQL)
ISNULL (Transact-SQL)
ISNUMERIC (Transact-SQL)
Key_GUID (Transact-SQL)
Key_ID (Transact-SQL)
KEY_NAME (Transact-SQL)
KILL (Transact-SQL)
KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL)
KILL STATS JOB (Transact-SQL)
LEFT (Transact-SQL)
LEN (Transact-SQL)
LIKE (Transact-SQL)
LOG (Transact-SQL)
LOG10 (Transact-SQL)
LOGINPROPERTY (Transact-SQL)
LOWER (Transact-SQL)
LTRIM (Transact-SQL)
MAX (Transact-SQL)
MERGE (Transact-SQL)
MIN (Transact-SQL)
MIN_ACTIVE_ROWVERSION (Transact-SQL)
money e smallmoney (Transact-SQL)
MONTH (Transact-SQL)
MOVE CONVERSATION (Transact-SQL)
NCHAR (Transact-SQL)
nchar e nvarchar (Transact-SQL)
NEWID (Transact-SQL)
NEWSEQUENTIALID () (Transact-SQL)
NOT (Transact-SQL)
ntext, text e image (Transact-SQL)
NTILE (Transact-SQL)
NULLIF (Transact-SQL)
numeric (Transact-SQL)
OBJECT_DEFINITION (Transact-SQL)
OBJECT_ID (Transact-SQL)
OBJECT_NAME (Transact-SQL)
OBJECT_SCHEMA_NAME (Transact-SQL)
OBJECTPROPERTY (Transact-SQL)
OBJECTPROPERTYEX (Transact-SQL)
Funzioni scalari ODBC (Transact-SQL)
OPEN (Transact-SQL)
OPEN MASTER KEY (Transact-SQL)
OPEN SYMMETRIC KEY (Transact-SQL)
OPENDATASOURCE (Transact-SQL)
OPENQUERY (Transact-SQL)
OPENROWSET (Transact-SQL)
OPENXML (Transact-SQL)
Operatori (Transact-SQL)
Clausola OPTION (Transact-SQL)
OR (Transact-SQL)
Clausola ORDER BY (Transact-SQL)
ORIGINAL_DB_NAME (Transact-SQL)
ORIGINAL_LOGIN (Transact-SQL)
Clausola OUTPUT (Transact-SQL)
Clausola OVER (Transact-SQL)
PARSENAME (Transact-SQL)
PathName (Transact-SQL)
PATINDEX (Transact-SQL)
PERMISSIONS (Transact-SQL)
PI (Transact-SQL)
POWER (Transact-SQL)
Predicato (Transact-SQL)
PRINT (Transact-SQL)
PUBLISHINGSERVERNAME (Transact-SQL)
PWDCOMPARE (Transact-SQL)
PWDENCRYPT (Transact-SQL)
QUOTENAME (Transact-SQL)
RADIANS (Transact-SQL)
RAISERROR
RAND (Transact-SQL)
RANK (Transact-SQL)
READTEXT (Transact-SQL)
real (Transact-SQL)
RECEIVE (Transact-SQL)
RECONFIGURE (Transact-SQL)
REPLACE (Transact-SQL)
REPLICATE (Transact-SQL)
Parole chiave riservate (Transact-SQL)
Istruzioni RESTORE per il ripristino, il recupero e la gestione dei backup (Transact-SQL)
RESTORE MASTER KEY (Transact-SQL)
RESTORE SERVICE MASTER KEY (Transact-SQL)
RETURN (Transact-SQL)
REVERSE (Transact-SQL)
REVERT (Transact-SQL)
REVOKE (Transact-SQL)
RIGHT (Transact-SQL)
ROLLBACK TRANSACTION (Transact-SQL)
ROLLBACK WORK (Transact-SQL)
ROUND (Transact-SQL)
ROW_NUMBER (Transact-SQL)
ROWCOUNT_BIG (Transact-SQL)
rowversion (Transact-SQL)
RTRIM (Transact-SQL)
SAVE TRANSACTION (Transact-SQL)
SCHEMA_ID (Transact-SQL)
SCHEMA_NAME (Transact-SQL)
SCOPE_IDENTITY (Transact-SQL)
Condizione di ricerca (Transact-SQL)
SELECT @local_variable (Transact-SQL)
SELECT (Transact-SQL)
SEND (Transact-SQL)
SERVERPROPERTY (Transact-SQL)
SESSION_USER (Transact-SQL)
SESSIONPROPERTY (Transact-SQL)
SET @local_variable (Transact-SQL)
SET (Transact-SQL)
SETUSER (Transact-SQL)
SHUTDOWN (Transact-SQL)
SIGN (Transact-SQL)
SignByAsymKey (Transact-SQL)
SignByCert (Transact-SQL)
SIN (Transact-SQL)
smalldatetime (Transact-SQL)
smallint (Transact-SQL)
smallmoney (Transact-SQL)
SOME | ANY (Transact-SQL)
SOUNDEX (Transact-SQL)
SPACE (Transact-SQL)
sql_variant (Transact-SQL)
SQL_VARIANT_PROPERTY (Transact-SQL)
SQRT (Transact-SQL)
SQUARE (Transact-SQL)
STATS_DATE (Transact-SQL)
STDEV (Transact-SQL)
STDEVP (Transact-SQL)
STR (Transact-SQL)
STUFF (Transact-SQL)
SUBSTRING (Transact-SQL)
SUM (Transact-SQL)
SUSER_ID (Transact-SQL)
SUSER_NAME (Transact-SQL)
SUSER_SID (Transact-SQL)
SUSER_SNAME (Transact-SQL)
SWITCHOFFSET (Transact-SQL)
SYSDATETIME (Transact-SQL)
SYSDATETIMEOFFSET (Transact-SQL)
SYMKEYPROPERTY (Transact-SQL)
Stored procedure di sistema (Transact-SQL)
Tabelle di sistema (Transact-SQL)
Viste di sistema (Transact-SQL)
SYSUTCDATETIME (Transact-SQL)
sys.fn_builtin_permissions (Transact-SQL)
sys.fn_translate_permissions (Transact-SQL)
sys.fn_validate_plan_guide (Transact-SQL)
sys.login_token (Transact-SQL)
sys.user_token (Transact-SQL)
SYSTEM_USER (Transact-SQL)
table (Transact-SQL)
Costruttore di valori di tabella (Transact-SQL)
TAN (Transact-SQL)
TERTIARY_WEIGHTS (Transact-SQL)
text (Transact-SQL)
TEXTPTR (Transact-SQL)
TEXTVALID (Transact-SQL)
time (Transact-SQL)
tinyint (Transact-SQL)
TODATETIMEOFFSET (Transact-SQL)
TOP (Transact-SQL)
Flag di traccia (Transact-SQL)
Transazioni (Transact-SQL)
TRY...CATCH (Transact-SQL)
TRIGGER_NESTLEVEL (Transact-SQL)
TRUNCATE TABLE (Transact-SQL)
TYPE_ID (Transact-SQL)
TYPE_NAME (Transact-SQL)
TYPEPROPERTY (Transact-SQL)
UNICODE (Transact-SQL)
UNION (Transact-SQL)
uniqueidentifier (Transact-SQL)
UPDATE (Transact-SQL)
UPDATE() (Transact-SQL)
UPDATE STATISTICS (Transact-SQL)
UPDATETEXT (Transact-SQL)
UPPER (Transact-SQL)
USE (Transact-SQL)
USER (Transact-SQL)
USER_ID (Transact-SQL)
USER_NAME (Transact-SQL)
VAR (Transact-SQL)
varbinary (Transact-SQL)
varchar (Transact-SQL)
VARP (Transact-SQL)
VerifySignedByCert (Transact-SQL)
VerifySignedByAsymKey (Transact-SQL)
WAITFOR (Transact-SQL)
WHERE (Transact-SQL)
WHILE (Transact-SQL)
WITH common_table_expression (Transact-SQL)
WITH XMLNAMESPACES (Transact-SQL)
WRITETEXT (Transact-SQL)
XACT_STATE (Transact-SQL)
xml (Transact-SQL)
xml_schema_namespace (Transact-SQL)
YEAR (Transact-SQL)
Espandi Riduci a icona
Questo argomento non è stato ancora valutato - Valuta questo argomento

PWDENCRYPT (Transact-SQL)

SQL Server 2008

Restituisce l'hash della password di SQL Server per il valore di input che utilizza la versione corrente dell'algoritmo di hashing delle password.

PWDENCRYPT è una funzione precedente e potrebbe non essere supportata in una versione futura di SQL Server. Utilizzare invece HASHBYTES. HASHBYTES rende disponibili ulteriori algoritmi di hashing.

Icona di collegamento a un argomento Convenzioni della sintassi Transact-SQL

Copia 

PWDENCRYPT ( 'password' )
password

Password da crittografare. password è di tipo sysname.

varbinary(128)

PWDENCRYPT è disponibile per il ruolo public.

Il documento è risultato utile?
(1500 caratteri rimanenti)

Aggiunte alla community

AGGIUNGI
Microsoft sta conducendo un sondaggio in linea per comprendere l'opinione degli utenti in merito al sito Web di MSDN. Se si sceglie di partecipare, quando si lascia il sito Web di MSDN verrà visualizzato il sondaggio in linea.

Si desidera partecipare?
Informativa sulla privacy
© 2013 Microsoft
|
Commenti e suggerimenti sul sito
© 2013 Microsoft. Tutti i diritti riservati.