pub struct Mssql;Expand description
Microsoft SQL Server dialect: @PN placeholders, OUTPUT INSERTED.*,
bracket-quoted identifiers, BEGIN/COMMIT/ROLLBACK TRANSACTION. Upserts
require MERGE, which the engine post-processes; the upsert clause emits
empty.
Trait Implementations§
Source§impl SqlDialect for Mssql
impl SqlDialect for Mssql
Source§fn placeholder(&self, i: usize) -> String
fn placeholder(&self, i: usize) -> String
Emit the 1-indexed parameter placeholder for position
i.Source§fn returning_clause(&self, cols: &str) -> String
fn returning_clause(&self, cols: &str) -> String
Emit the clause (leading space included) that requests the given
columns be returned after an INSERT/UPDATE/DELETE. Postgres/SQLite/MySQL
emit
RETURNING cols; MSSQL emits OUTPUT INSERTED.cols.Source§fn quote_ident(&self, i: &str) -> String
fn quote_ident(&self, i: &str) -> String
Quote a table/column identifier for safe interpolation.
Source§fn upsert_clause(&self, _c: &[&str], _s: &str) -> String
fn upsert_clause(&self, _c: &[&str], _s: &str) -> String
Emit the ON CONFLICT / ON DUPLICATE KEY clause (leading space
included) that converts an INSERT into an upsert.
Source§fn commit_sql(&self) -> &'static str
fn commit_sql(&self) -> &'static str
SQL keyword that commits a transaction. Defaults to
COMMIT.Source§fn rollback_sql(&self) -> &'static str
fn rollback_sql(&self) -> &'static str
SQL keyword that rolls back a transaction. Defaults to
ROLLBACK.Source§fn supports_distinct_on(&self) -> bool
fn supports_distinct_on(&self) -> bool
Whether the dialect supports
SELECT DISTINCT ON (cols) (Postgres-only
among our backends today).Source§fn insert_has_returning(&self) -> bool
fn insert_has_returning(&self) -> bool
Whether an INSERT statement can use the dialect’s returning clause to
retrieve inserted rows in-place.
Auto Trait Implementations§
impl Freeze for Mssql
impl RefUnwindSafe for Mssql
impl Send for Mssql
impl Sync for Mssql
impl Unpin for Mssql
impl UnsafeUnpin for Mssql
impl UnwindSafe for Mssql
Blanket Implementations§
Source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
Source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more