REQUEST DEMO
Contact us
en
English
Dansk
Deutsch
Ελληνικά
Español
Italiano
Português
en
en
da
de
el
es
it
pt
Community
>
Documentation
TARGIT InMemory
TARGIT InMemory Database
What is TARGIT InMemory Database
What is an In-Memory Database
Benefits of In-Memory
Typical import speed
Database Configuration
Database Server (tiServer.exe)
TARGITDB.INI
Import Tool
Importing into TARGIT InMemory Database
tiImport Reference Guide
Alter Table Add Column
Clustered Index
VAREXISTS
Create Table
Columnize
Data Sources
DOT NET Datasource
ME Datasource
Declare
Drop
Execute
Exit
File Exists
Flush
For
ForceGC
If
Import
Import Timeout
Insert Into
Move Next
Print
Save
Set
Set Culture
Supported Cultures
Slurp
TryCatch
While
Refreshing TARGIT InMemory Database
tiImport Command Prompt
tiImport TARGIT SSIS InMemory Custom Import
tiLoad
InMemory Data Drivers
CSV
Excel
FileList
Fixed Width
Google Big Query
MongoDB
Query Tool
Starting tiQuery
tiQuery - General Shortcuts/Tips
ETL Studio
ETL Studio
Let's get started
Project Properties
Adding Data Source
Toolbox Rundown
Bulk Import
ClusteredIndex
Condition
Drop
Enum
Execute
Exit
Group
Import
Parallel
Save
Script
Slurp
Union
Code Generation
Scheduler
Scheduler Management
Schedules
Security
Assemblies
Deployment Folders
Auto Update Settings
Notifications
SQL Language Reference
Rename
Select
Cache
Case
Count
Delete
Group By
Having
Joins
Left Join
Cross Join
Inner Join
Right Join
Limit
Nocache
Order By
Select Distinct
Select*
Union All
Where
Update
Function Overview
Functions
ABS
ACOS
ASCII
ASIN
ATAN
ATAN2
AVG
CAST
CAST_NUM_AS_BYTE
CAST_NUM_AS_DECIMAL
CAST_NUM_AS_DOUBLE
CAST_NUM_AS_INT
CAST_NUM_AS_LONG
CAST_NUM_AS_SHORT
CAST_NUM_AS_SINGLE
CAST_STR_AS_DECIMAL
CAST_STR_AS_DOUBLE
CAST_STR_AS_LONG
CDATE
CHAR
CHARINDEX
CLOSEBAL
COALESCE
CONCAT
COS
COSH
COUNT
CSTR
DATE
DATEADD
DATEDIFF
DATEDIFFMILLISECOND
DATEPART
DATESERIAL
DAY
DAYOFWEEK
ENDSWITH
FLOOR
FORMAT
GETDATE
IIF
INSERT
ISNULL
ISNULLOREMPTY
LEFT
LEN
LCASE
LOG ( NUMBER )
LOG ( NUMBER, BASE )
LTRIM ( SOME_STRING )
MAX
MAXLIST
MIN
MINLIST
MONTH
OPENBAL
POW
RAND
REMOVE
REPLACE
REVERSE
RIGHT
ROUND
RTRIM
SAFECAST
SIGN
SIN
SINH
SRQT
STARTSWITH
STDEV | STDDEV
STDEV_P | STDDEV_P
SUBSTRING
SUM
TAN
TANH
TRIM
TRUNC
UCASE
VAR | VARIANCE
VARP | VARIANCE_P
YEAR
System Specific Tables
Columns
Tables
Updated
CAST_NUM_AS_SHORT ( number )
returns a short corresponding to
number
See Also:
CAST
,
SAFECAST