SQL Server
España (Español) Iniciar sesión
Inicio 2012 2008 R2 2008 Versiones anteriores Library Foros
Biblioteca TechNet
SQL Server
SQL Server 2008
Documentación del producto
Libros en pantalla de SQL Server 2008
Motor de base de datos
Referencia técnica
Referencia de Transact-SQL
Convenciones de sintaxis de Transact-SQL (Transact-SQL)
Tutorial: Escribir instrucciones Transact-SQL
+ (Sumar) (Transact-SQL)
+ (Suma unaria) (Transact-SQL)
+ (Concatenación de cadenas) (Transact-SQL)
+= (Sumar igual) (Transact-SQL)
+= (Concatenación de cadenas) (Transact-SQL)
- (valor negativo) (Transact-SQL)
- (restar) (Transact-SQL)
-= (Restar igual) (Transact-SQL)
* (Multiplicar) (Transact-SQL)
*= (Multiplicar igual a) (Transact-SQL)
/ (Dividir) (Transact-SQL)
/= (Dividir igual) (Transact-SQL)
\ (barra diagonal inversa) (Transact-SQL)
% (Módulo) (Transact-SQL)
%= (Módulo igual) (Transact-SQL)
% (caracteres comodín para coincidir) (Transact-SQL)
& (AND bit a bit) (Transact-SQL)
&= (AND bit a bit igual) (Transact-SQL)
| (OR bit a bit) (Transact-SQL)
|= (OR bit a bit igual) (Transact-SQL)
^ (OR exclusivo bit a bit) (Transact-SQL)
^= (OR exclusivo bit a bit igual) (Transact-SQL)
~ (NOT bit a bit) (Transact-SQL)
= (Igual a) (Transact-SQL)
> (Mayor que) (Transact-SQL)
< (Menor que) Transact-SQL)
>= (Mayor o igual que) (Transact-SQL)
<= (Menor o igual que) (Transact-SQL)
<> (Distinto de) (Transact-SQL)
!< (No menor que) (Transact-SQL)
!= (No es igual a) (Transact-SQL)
!> (No mayor que) (Transact-SQL)
-- (Comentarios) (Transact-SQL)
/*...*/ (comentario de Transact-SQL)
[ ] (caracteres comodín para búsqueda de coincidencias de Transact-SQL)
[^] (comodín - carácter o caracteres no coincidentes) (Transact-SQL)
_ (comodín, coincidir un carácter) (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)
Instrucciones 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 y varbinary (Transact-SQL)
BINARY_CHECKSUM (Transact-SQL)
bit (Transact-SQL)
BREAK (Transact-SQL)
BULK INSERT (Transact-SQL)
CASE (Transact-SQL)
CAST y CONVERT (Transact-SQL)
CATCH (TRY...CATCH) (Transact-SQL)
CEILING (Transact-SQL)
CertProperty (Transact-SQL)
Cert_ID (Transact-SQL)
Funciones de captura de datos modificados (Transact-SQL)
Funciones de seguimiento de cambios (Transact-SQL)
char y 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)
Operadores compuestos (Transact-SQL)
COMPUTE (Transact-SQL)
CONNECTIONPROPERTY (Transact-SQL)
Constantes (Transact-SQL)
CONTAINS (Transact-SQL)
CONTAINSTABLE (Transact-SQL)
CONTINUE (Transact-SQL)
CONTEXT_INFO (Transact-SQL)
Lenguaje de control de flujo (Transact-SQL)
CONVERT (Transact-SQL)
COS (Transact-SQL)
COT (Transact-SQL)
COUNT (Transact-SQL)
COUNT_BIG (Transact-SQL)
Instrucciones 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)
Cursores (Transact-SQL)
Funciones de recopilador de datos (Transact-SQL)
Tipos de datos (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 y 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)
Instrucciones 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)
EXECUTE AS (cláusula de Transact-SQL)
EXECUTE
EXISTS (Transact-SQL)
EXP (Transact-SQL)
Expresiones (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 y 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)
FOR (cláusula de Transact-SQL)
FORMATMESSAGE (Transact-SQL)
FREETEXT (Transact-SQL)
FREETEXTTABLE (Transact-SQL)
FROM (Transact-SQL)
FULLTEXTCATALOGPROPERTY (Transact-SQL)
FULLTEXTSERVICEPROPERTY (Transact-SQL)
Funciones (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)
Sugerencias (Transact-SQL)
HOST_ID (Transact-SQL)
HOST_NAME (Transact-SQL)
IDENT_CURRENT (Transact-SQL)
IDENT_INCR (Transact-SQL)
IDENT_SEED (Transact-SQL)
IDENTITY (Función) (Transact-SQL)
IDENTITY (propiedad de 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 y tinyint (Transact-SQL)
INTO (cláusula de 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 y smallmoney (Transact-SQL)
MONTH (Transact-SQL)
MOVE CONVERSATION (Transact-SQL)
NCHAR (Transact-SQL)
nchar y 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)
Funciones escalares de 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)
Operadores (Transact-SQL)
OPTION (cláusula de Transact-SQL)
OR (Transact-SQL)
ORDER BY (cláusula de Transact-SQL)
ORIGINAL_DB_NAME (Transact-SQL)
ORIGINAL_LOGIN (Transact-SQL)
OUTPUT (cláusula de Transact-SQL)
OVER (cláusula de Transact-SQL)
PARSENAME (Transact-SQL)
PathName (Transact-SQL)
PATINDEX (Transact-SQL)
PERMISSIONS (Transact-SQL)
PI (Transact-SQL)
POWER (Transact-SQL)
Predicado (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)
Palabras clave reservadas (Transact-SQL)
Instrucciones RESTORE para restaurar, recuperar y administrar copias de seguridad (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)
Condiciones de búsqueda (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)
Procedimientos almacenados del sistema (Transact-SQL)
Tablas del sistema (Transact-SQL)
Vistas del 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)
Constructor con valores de tabla (Transact-SQL)
TAN (Transact-SQL)
TERTIARY_WEIGHTS (Transact-SQL)
text (Transact-SQL)
TEXTPTR (Transact-SQL)
TEXTVALID (Transact-SQL)
hora (Transact-SQL)
tinyint (Transact-SQL)
TODATETIMEOFFSET (Transact-SQL)
TOP (Transact-SQL)
Marcadores de seguimiento (Transact-SQL)
Transacciones (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)
Expandir Minimizar
Este tema aún no ha recibido ninguna valoración - Valorar este tema

STDEVP (Transact-SQL)

SQL Server 2008

Devuelve la desviación estadística estándar para la población de todos los valores de la expresión especificada. Puede ir seguida de la cláusula OVER.

Icono de vínculo a temas Convenciones de sintaxis de Transact-SQL

Copiar 

STDEVP ( [ ALL | DISTINCT ] expression )
ALL

Aplica la función a todos los valores. ALL es el valor predeterminado.

DISTINCT

Especifica que se tiene en cuenta cada valor único.

expression

Es una expresión numérica. No se permiten las funciones de agregado ni las subconsultas. expression es una expresión de la categoría de tipo de datos numérico exacto o numérico aproximado, excepto para el tipo de datos bit.

Si se utiliza STDEVP en todos los elementos de una instrucción SELECT, se incluirán en el cálculo todos los valores del conjunto de resultados. STDEVP sólo puede utilizarse con columnas numéricas. Los valores NULL se pasan por alto.

En el ejemplo siguiente se devuelve la desviación estándar de la población de todos los valores de bonificación de la tabla SalesPerson.

Copiar 
USE AdventureWorks;
GO
SELECT STDEVP(Bonus)
FROM Sales.SalesPerson;
GO
¿Te ha resultado útil?
(Caracteres restantes: 1500)

Adiciones de comunidad

AGREGAR
© 2013 Microsoft
|
Comentario del sitio
© 2013 Microsoft. Reservados todos los derechos.