Microsoft SQL Server Query Features: Difference between revisions
Jump to navigation
Jump to search
(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.") |
(No difference)
|
Revision as of 16:18, 27 February 2024
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.