Home > Products > TerraForm > Documentation > Formats, datatypes and presets >

Microsoft SQL Server Extension Pack

The Microsoft SQL Server Extension Pack contains a set of datatypes that correspond to data types available within Microsoft Server. Note that you can successfully use the standard TerraForm datatypes with Server, but these may prove useful. If a field in your database uses the Server TinyInt data type, for example, you can simply specify sqTinyInt as the datatype within a field of your form and be sure that TerraForm will make sure that only TinyInt-size data gets by! All the datatypes in this Pack are prefixed with "sq" to avoid conflicting with predefined datatypes and datatypes from other packes.

To use this datatype pack, open customtags/terraform/settings.cfm and find section 5. Remove the comment tags from the following line:

<!--- <cfinclude template="datatypes/mssqlserver.cfm"> --->

sqBigInt
sqBit
sqChar
sqDateTime
sqDecimal
sqFloat
sqInt

sqMoney
sqNChar
sqNText
sqNumeric
sqNVarChar
sqReal

sqSmallDateTime
sqSmallInt
sqSmallMoney
sqText
sqTinyInt
sqVarChar

Examples

sqBigInt

An integer between -9223372036854775808 and 9223372036854775807.

<cf_terrafield
  name="sqBigInt"
  datatype="sqBigInt"
/>

sqBit

A binary digit (0 or 1).

<cf_terrafield
  name="sqBit"
  datatype="sqBit"
/>

sqBit

sqChar

A character string up to 8000 characters.

<cf_terrafield
  name="sqChar"
  datatype="sqChar"
/>

sqDateTime

A date/time value between 1 January 1753 and 31 December 9999.

<cf_terrafield
  name="sqDateTime"
  datatype="sqDateTime"
/>

sqDecimal

A real number between -10^38+1 and 10^38-1.

<cf_terrafield
  name="sqDecimal"
  datatype="sqDecimal"
/>

sqFloat

A real number between -1.79E+308 and 1.79E+308.

<cf_terrafield
  name="sqFloat"
  datatype="sqFloat"
/>

sqInt

An integer between -2147483648 and 2147483647.

<cf_terrafield
  name="sqInt"
  datatype="sqInt"
/>

sqMoney

An real number between -9223372036854775808 and 9223372036854775807.

<cf_terrafield
  name="sqMoney"
  datatype="sqMoney"
/>

sqNChar

A character string up to 4000 characters.

<cf_terrafield
  name="sqNChar"
  datatype="sqNChar"
/>

sqNText

A character string up to 1073741823 characters.

<cf_terrafield
  name="sqNText"
  datatype="sqNText"
/>

sqNumeric

A real number between -10^38+1 and 10^38-1.

<cf_terrafield
  name="sqNumeric"
  datatype="sqNumeric"
/>

sqNVarChar

A character string up to 4000 characters.

<cf_terrafield
  name="sqNVarChar"
  datatype="sqNVarChar"
/>

sqReal

A real number between -3.40E+38 and 3.40E+38.

<cf_terrafield
  name="sqReal"
  datatype="sqReal"
/>

sqSmallDateTime

A date/time value between 1 January 1900 and 6 June 2079.

<cf_terrafield
  name="sqSmallDateTime"
  datatype="sqSmallDateTime"
/>

sqSmallInt

An integer between -32768 and 32767.

<cf_terrafield
  name="sqSmallInt"
  datatype="sqSmallInt"
/>

sqSmallMoney

A real number between -214748.3648 and 214748.3647.

<cf_terrafield
  name="sqSmallMoney"
  datatype="sqSmallMoney"
/>

sqText

A character string up to 2147483647 characters.

<cf_terrafield
  name="sqText"
  datatype="sqText"
/>

sqTinyInt

An integer between 0 and 255.

<cf_terrafield
  name="sqTinyInt"
  datatype="sqTinyInt"
/>

sqVarChar

A character string up to 8000 characters.

<cf_terrafield
  name="sqVarChar"
  datatype="sqVarChar"
/>

Structured Query Language

A language for getting information from and updating a database.