SQL Queries
Last updated
Last updated
Starcounter 3.0 has the same SQL Query Processor as Starcounter 2.3.2. Please refer to the for the full specification.
As of right now the following DDL statements are supported:
There is no one to one match between Starcounter database data types and .NET CLR data types.
Use the following table to translate .NET CLR data type names into Starcounter database SQL data type names.
.NET CLR Data Type
Starcounter database data type
Boolean
boolean
Byte
int
Byte[]
binary
DateTime
uint
Decimal
decimal
Double
double
Float
float
Int16
int
Int32
int
Int64
int
SByte
int
String
text
UInt16
uint
UInt32
uint
UInt64
uint