Microsoft SQL Server Query Features

From KeystoneIntranet
Revision as of 16:18, 27 February 2024 by Chanson (talk | contribs) (Created page with "===trim=== ltrim rtrim select trim(address1) from Customer ===concat=== ===replace=== Replace singele quote with 2 single quotes: <code>replace(rtrim(ltrim(NAME)),'''','''''') "DRIVER_NAME",</code> ===left, right=== ===case=== ===iif=== ===windowing functions=== ===rank=== ===derived queries=== Derived queries, fequently seen as a "with" statement... allow for querying queries.")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

trim

ltrim rtrim

select trim(address1) from Customer

concat

replace

Replace singele quote with 2 single quotes: replace(rtrim(ltrim(NAME)),',') "DRIVER_NAME",

left, right

case

iif

windowing functions

rank

derived queries

Derived queries, fequently seen as a "with" statement... allow for querying queries.

Retrieved from "http://in.compucrete.com/index.php?title=Microsoft_SQL_Server_Query_Features&oldid=958"