Microsoft SQL Server Query Features - Revision history

Chanson: /* iif */

2024-02-27T16:25:04Z

iif

← Older revision		Revision as of 16:25, 27 February 2024
Line 24:		Line 24:
	===case===		===case===
	===iif===		===iif===
			Similar to using a case statement, iif gives allows you 2 responses to an if condition..

			<code>iif(rtrim(LTRIM(INACTIVE_CODE))='00','Y','N') active_flag,</code>

	===windowing functions===		===windowing functions===

Chanson: /* concat */

2024-02-27T16:24:12Z

concat

← Older revision		Revision as of 16:24, 27 February 2024
Line 9:		Line 9:
	<code>select trim(address1) from Customer</code>		<code>select trim(address1) from Customer</code>

	===~~concat~~===		===Concat===
			Use concat instead of the "\|\|" characters used in Interbase to concatenate.

			Example...
			<code>CONCAT('Acct Cat Code: ',RTRIM(LTRIM(ACCT_CAT_CODE))) USER_2,</code>

	===replace===		===replace===

Chanson: /* trim */

2024-02-27T16:20:58Z

trim

← Older revision		Revision as of 16:20, 27 February 2024
Line 1:		Line 1:
	===trim===		===trim===
	ltrim rtrim		Commands: trim, ltrim, rtrim
			The trim commands will trim spaces from the beginning and end of strings.

	select trim(address1) from Customer		In older MS SQL you must use ltrim and rtrim together to trim both ends of a string...
			<code>select rtrim(ltrim(address1)) from Customer</code>

			Modern MS SQL allows for just trim...
			<code>select trim(address1) from Customer</code>

	===concat===		===concat===

Chanson: Created page with "===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."

2024-02-27T16:18:27Z

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."

New page

===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.