Ir al contenido
Manual Crono SQL
Buscar
Ctrl
K
Cancelar
Crono
Seleccionar tema
Oscuro
Claro
Automático
Crono Analysis
Crono Metadata
Crono ETL
Crono SQL
Ejemplos Starlight
Introducción
Lenguaje Crono SQL
Sentencia SELECT
Sentencia INSERT
Sentencia UPDATE
Sentencias MERGE
Sentencia DELETE
Sentencia TRUNCATE
Sentencias DDL
Lenguaje Crono SQL
Referencia del lenguaje
Sentencias principales
Palabras reservadas de Crono SQL
CHECK SNOWFLAKE
FILE
INTEGERS BETWEEN
JOIN
MATERIALIZE
OVER 🚧
ROWS y COLUMNS
SELECTs anidados
Tabla de tiempo
UNPIVOT
Referencia del lenguaje
Funciones
abc
abs
acos
adddays
addition ❇️
ascii
asin
atan
atn2
average
avg
bighex ❇️ 🚧
bigint ❇️ 🚧
binary_checksum
bit ❇️ 🚧
cast
ceiling
char
charindex
checksum
checksum_agg
choose
coalesce ❇️
col_length
col_name
collationproperty
columnproperty
columns_updated
compress
concat
concat_ws
convert 🚧
cos
cot
count
count_big
countvalues
cume_dist
current_catalog
current_date ❇️ 🚧
current_time ❇️ 🚧
current_timestamp
current_timezone
current_timezone_id
current_transaction_id
current_user
current_year
currentusername ❇️
cursor_status
database_principal_id
databaseproperty 🚧
databasepropertyex
datalength
date
date_bucket
dateadd
datediff
datediff_big
datefromparts
datename
datepart
datetime ❇️ 🚧
datetime2 ❇️ 🚧
datetime2fromparts
datetimefromparts
datetimeoffsetfromparts
datetrunc
day
daysago
daysdiff
db_id
db_name
decile
decompress
degrees
dense_rank
difference
divide
elementat
emptyifnull
end_date
end_datetime
eomonth
error_line
error_message
error_number
error_procedure
error_severity
error_state
exp
file_name
filegroup_id
filegroup_name
filegroupproperty
fileproperty
first_value
float ❇️ 🚧
floor
format
formatmessage
fromjuliandate
fromunixdate
fulltextcatalogproperty
fulltextserviceproperty
generate_series
getansinull
getdate
getenddate ❇️ 🚧
getenddatetime ❇️ 🚧
getutcdate
greatest
has_dbaccess
hashbytes
hex ❇️ 🚧
host_id
host_name
hour
ident_current
ident_incr
ident_seed
identity
iif
index_col
Funciones de agregación
Funciones de conversión y lógicas
Funciones de fecha
Funciones matemáticas
Funciones misceláneas
Funciones de sistema
Funciones de texto
indexof
indexproperty
int ❇️ 🚧
is_first
is_last
is_member
is_srvrolemember
isdate
ismemberof
isnull
isnumeric
isodate
isoweek
isoweekcode
isoweekshortcode
isoweekyear
juliandate
lag
last_value
lead
least
left ❇️
len
localdate
localdatetimeoffset
log
log10
lower
ltrim
margin
markup
max
maximum
md5 ❇️ 🚧
memberof
min
minimum
mod
month
nameof ❇️ 🚧
nchar
newid
newsequentialid
next_value
ntile
nullif 🚧
nullifempty
nullifzero
object_id
object_name
objectproperty
opendatasource
openquery
openrowset
parse
parsename
patindex
pct
pctrank
pctvariance ❇️ 🚧
percent_rank
percentile
percentile_cont
percentile_disc
permissions
pi
power
previous_value
previousday
quantile
quartile
quotename
radians
rand
rank
Funciones
replace
replicate
reverse
right
round ❇️
row_number
rowcount_big
rtrim
runningpct
runningsum
schema_id
schema_name
scope_identity
security
serverproperty
session_user
sessionproperty
sha1 ❇️ 🚧
sha256 ❇️ 🚧
sign
sin
single ❇️ 🚧
smalldatetimefromparts
smallhex ❇️ 🚧
smallint ❇️ 🚧
soundex
space
split
sql_variant_property
sqrt
square
stats_date
stdev
stdevp
str
string_agg
string_split
stuff
substraction
substring
sum
suser_id
suser_name
suser_sid
suser_sname
switch
switchoffset
sysdatetime
sysdatetimeoffset
system_user
sysutcdatetime
tan
time ❇️ 🚧
timefromparts
tinyhex ❇️ 🚧
tinyint ❇️ 🚧
todatetimeoffset
today
tomorrow
total
trim
try_cast
try_convert
try_parse
type_name
typeproperty
uchar
unicode
unicodechar ❇️ 🚧
upper
user_name
valueof ❇️ 🚧
var
varp
weekday
weekdaynumber
year
yesterday
yyyy
yyyymm
yyyymmdd ❇️ 🚧
zeroifnull
Sentencias
BACKUP DATABASE
Vistas
Crono$ActionProperties
Crono$Actions
Crono$ActiveDirectoryGroups
Crono$ActiveDirectoryGroupsOf
Crono$ActiveDirectoryMyGroups
Crono$ActiveDirectoryUsers
Crono$AnsiColumns
Crono$AnsiForeignKeys
Crono$ColumnExtendedProperties
Crono$Columns
Crono$Constraints
Crono$ConstraintsColumns
Crono$Countries
Crono$CronoFunctions
Crono$CronoViewProperties
Crono$CronoViews
Crono$Csv
Crono$DatabaseExtendedProperties
Crono$Databases
Crono$Dates
Crono$Emojis
Crono$Excel
Crono$ExcelRange
Crono$ForeignKeys
Crono$Functions
Crono$GetData
Crono$GetSchema
Crono$HttpStatusCode
Crono$IndexColumns
Crono$Indexes
Crono$Keywords
Crono$Logs
Crono$LogTable
Crono$Months
Crono$NamedDirectories
Crono$Parameters
Crono$ProcedureExtendedProperties
Crono$Procedures
Crono$Replacements
Crono$Routines
Crono$Schemas
Crono$ServerProperties
Crono$SpanishCities
Crono$SpanishProvinces
Crono$SpanishRegions
Crono$SqlFunctions
Crono$Statistics
Crono$TableExtendedProperties
Crono$Tables
Crono$TablesInfo
Crono$TableSizes
Crono$TimeZones
Crono$Transactions
Crono$UnicodeChars
Crono$UnicodeTable
Crono$Union
Crono$UnionAll
Crono$Weeks
Vistas del Directorio Activo
Vistas de base de datos
Vistas de metadata de Crono
Vistas misceláneas
Vistas de tiempo
Vistas
Crono
Seleccionar tema
Oscuro
Claro
Automático
datetime ❇️ 🚧