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

STDEV (Transact-SQL)

Restituisce la deviazione statistica standard di tutti i valori nell'espressione specificata. Può precedere la clausola OVER.

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

Copia 

STDEV ( [ ALL | DISTINCT ] expression )
ALL

Applica la funzione a tutti i valori. Il valore predefinito è ALL.

DISTINCT

Consente di considerare ogni valore univoco.

expression

Espressione numerica. Le funzioni di aggregazione e le subquery non sono consentite. L'argomento expression è un'espressione con un tipo di dati compreso nella categoria dei tipi numerici esatti o approssimati, ad eccezione del tipo di dati bit.

Se si utilizza la funzione STDEV per tutti gli elementi di un'istruzione SELECT, ogni valore del set di risultati viene incluso nel calcolo. STDEV può essere utilizzata solo con colonne numeriche. I valori Null vengono ignorati.

Nell'esempio seguente viene restituita la deviazione standard per tutti i valori dei premi produzione nella tabella SalesPerson.

Copia 
USE AdventureWorks;
GO
SELECT STDEV(Bonus)
FROM Sales.SalesPerson;
GO
Il documento è risultato utile?
(1500 caratteri rimanenti)

Aggiunte alla community

AGGIUNGI
© 2013 Microsoft
|
Commenti e suggerimenti sul sito
© 2013 Microsoft. Tutti i diritti riservati.