[−][src]Trait tiberius::ToSql
A conversion trait to a TDS type.
A ToSql implementation for a Rust type is needed for using it as a
parameter in the Client#query or Client#execute methods. The
following Rust types are already implemented to match the given server
types:
| Rust type | Server type |
|---|---|
u8 | tinyint |
i16 | smallint |
i32 | int |
i64 | bigint |
f32 | float(24) |
f64 | float(53) |
bool | bit |
String/&str (< 4000 characters) | nvarchar(4000) |
String/&str | nvarchar(max) |
Vec<u8>/&[u8] (< 8000 bytes) | varbinary(8000) |
Vec<u8>/&[u8] | varbinary(max) |
Uuid | uniqueidentifier |
Numeric | numeric/decimal |
Decimal (with feature flag rust_decimal) | numeric/decimal |
BigDecimal (with feature flag bigdecimal) | numeric/decimal |
XmlData | xml |
NaiveDate (with chrono feature, TDS 7.3 >) | date |
NaiveTime (with chrono feature, TDS 7.3 >) | time |
DateTime (with chrono feature, TDS 7.3 >) | datetimeoffset |
NaiveDateTime (with chrono feature, TDS 7.3 >) | datetime2 |
NaiveDateTime (with chrono feature, TDS 7.2) | datetime |
It is possible to use some of the types to write into columns that are not
of the same type. For example on systems following the TDS 7.3 standard (SQL
Server 2008 and later), the chrono type NaiveDateTime can also be used to
write to datetime, datetime2 and smalldatetime columns. All string
types can also be used with ntext, text, varchar, nchar and char
columns. All binary types can also be used with binary and image
columns.
See the time module for more information about the date and time structs.
Required methods
pub fn to_sql(&self) -> ColumnData<'_>[src]
Convert to a value understood by the SQL Server. Conversion by-reference.
Implementations on Foreign Types
impl ToSql for bool[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<bool>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<bool>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for u8[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<u8>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<u8>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for i16[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<i16>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<i16>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for i32[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<i32>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<i32>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for i64[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<i64>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<i64>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for f32[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<f32>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<f32>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for f64[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<f64>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<f64>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &str[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<&str>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<&str>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for String[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<String>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<String>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Cow<'_, str>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<Cow<'_, str>>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<Cow<'_, str>>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &[u8][src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<&[u8]>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<&[u8]>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Cow<'_, [u8]>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<Cow<'_, [u8]>>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<Cow<'_, [u8]>>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Vec<u8>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<Vec<u8>>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<Vec<u8>>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<Numeric>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<Numeric>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<XmlData>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<XmlData>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<Uuid>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<Uuid>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<Decimal>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<Decimal>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<BigDecimal>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<BigDecimal>[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<NaiveDate>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<NaiveDate>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<NaiveTime>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<NaiveTime>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<NaiveDateTime>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<NaiveDateTime>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<DateTime<Utc>>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<DateTime<Utc>>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Option<DateTime<FixedOffset>>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for &Option<DateTime<FixedOffset>>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
Implementors
impl ToSql for BigDecimal[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Decimal[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Numeric[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for Uuid[src]
pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for DateTime<FixedOffset>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for DateTime<Utc>[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for NaiveDate[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for NaiveDateTime[src]
This is supported on crate feature
chrono only.pub fn to_sql(&self) -> ColumnData<'_>[src]
impl ToSql for NaiveTime[src]
This is supported on crate feature
chrono only.