SELECT CASE – SQL Server Syntax Example: SELECT CASE – T-SQL Example
SELECT CASE – SQL Server Syntax Example: SELECT CASE – T-SQL Example Purpose: – Illustrates the SQL Server syntax for the SELECT CASE CLAUSE . SYNTAX: Simple CASE expression: CASE input_expression WHEN when_expression THEN result_expression [ …n ] [ ELSE else_result_expression ] END Searched CASE expression: CASE WHEN Boolean_expression THEN result_expression... [Read More...]
Bitwise – SQL Server Syntax Example: Bitwise – T-SQL Example
Bitwise – SQL Server Syntax Example: Bitwise – T-SQL Example Purpose: – Illustrates the SQL Server syntax for the Bitwise operator . Syntax: operand1 bitwiseoperator operand2 – You can and (&), or(|), exclusively or (^) bits between two columns. The operands for bitwise operators can be any one of the data types of the integer or binary string data type categories (except for the image data type), except that both... [Read More...]
BETWEEN AND – SQL Server Syntax Example: BETWEEN AND – T-SQL Example
BETWEEN AND – SQL Server Syntax Example: BETWEEN AND – T-SQL Example Purpose: – Illustrates the SQL Server syntax for the BETWEEN AND . Syntax: SELECT [ ALL | DISTINCT ] [TOP ( expression ) [PERCENT] [ WITH TIES ] ] select_list [ INTO new_table ] [ FROM { table_source } [ ,…n ] ] [ WHERE column1 BETWEEN lowerbound AND upperbound ] [ GROUP BY ] [ HAVING search_condition ] – AS allows... [Read More...]
Column AS Alias SQL Server Syntax Example: Column AS T-SQL Example
SELECT AS SQL Server Syntax Example: SELECT AS T-SQL Example Purpose: – Illustrates the SQL Server syntax for the SELECT AS . Syntax: SELECT [ ALL | DISTINCT ] [TOP ( expression ) [PERCENT] [ WITH TIES ] ] column1 AS displayname1, column2 AS displayname2 [ INTO new_table ] [ FROM { table_source } [ ,…n ] ] [ WHERE search_condition AND search_condition ] [ GROUP BY ] [ HAVING search_condition ] –... [Read More...]
SELECT AND SQL Server Syntax Example: SELECT AND logical operator T-SQL Example
SELECT AND SQL Server Syntax Example: SELECT AND logical operator T-SQL Example Purpose: – Illustrates the SQL Server syntax for the SELECT and logical operator. Syntax: SELECT [ ALL | DISTINCT ] [TOP ( expression ) [PERCENT] [ WITH TIES ] ] select_list [ INTO new_table ] [ FROM { table_source } [ ,…n ] ] [ WHERE search_condition AND search_condition ] [ GROUP BY ] [ HAVING search_condition ] –... [Read More...]
SELECT ALL SQL Server Syntax Example: SELECT ALL argument T-SQL Example
SELECT ALL SQL Server Syntax Example: SELECT ALL argument T-SQL Example Purpose: – Illustrates the SQL Server syntax for the SELECT all argument. Syntax: SELECT [ ALL | DISTINCT ] [TOP ( expression ) [PERCENT] [ WITH TIES ] ] select_list [ INTO new_table ] [ FROM { table_source } [ ,…n ] ] [ WHERE search_condition ] [ GROUP BY ] [ HAVING search_condition ] – ALL indicates that duplicates are included... [Read More...]
Subquery ALL SQL Server Example: Subquery ALL modifier Example
Subquery ALL SQL Server Example: Subquery ALL modifier Example Purpose: – Illustrates the SQL Server syntax for the subquery all modifier. Syntax: WHERE expression comparison_operator [ANY | ALL] (subquery) – ALL in subquery means all rows in the subquery must meet the condition View Other SQL Server Syntax Examples -- SUBQUERY ALL -- PURPOSE: ALL in subquery means all rows in the subquery must meet the condition -- SYNTAX For... [Read More...]
clientX JavaScript (JS) Example: HTML DOM Objects – Mouse/Keyboard Attributes – clientX JavaScript (JS) Example
clientX JavaScript (JS) Example: HTML DOM Objects – Mouse/Keyboard Attributes – clientX JavaScript (JS) Example Purpose: – Illustrates the JavaScript syntax for the clientX Event Attribute. View Other Attributes and Handlers for DOM Events Prerequistes: Install Visual Web Developer 2008 Syntax: event.clientX – returns the horizontal coordinate of the client area) indicating the position of the mouse pointer when an event... [Read More...]
button JavaScript (JS) Example: HTML DOM Objects – Mouse/Keyboard Attributes – button JavaScript (JS) Example
button JavaScript (JS) Example: HTML DOM Objects – Mouse/Keyboard Attributes – button JavaScript (JS) Example Purpose: – Illustrates the JavaScript syntax for the button Event Attribute. View Other Attributes and Handlers for DOM Events Prerequistes: Install Visual Web Developer 2008 Syntax: event.button=0|1|2 0 = left 1 = middle 2 = right internet explorer: 1 = left 4 = middle 2 = right Since 2 is always right, you can say... [Read More...]
altkey JavaScript (JS) Example: HTML DOM Objects – Mouse/Keyboard Attributes – altkey JavaScript (JS) Example
altkey JavaScript (JS) Example: HTML DOM Objects – Mouse/Keyboard Attributes – altkey JavaScript (JS) Example Purpose: – Illustrates the JavaScript syntax for the altkey Event Attribute. View Other Attributes and Handlers for DOM Events Prerequistes: Install Visual Web Developer 2008 Syntax: event.altKey=true|false|1|0 – Allows you to know when altkey is pressed. Restrictions: None Notes: You can build your own library... [Read More...]
onsubmit JavaScript (JS) Example: HTML DOM Objects – Event – onsubmit JavaScript (JS) Example
onsubmit JavaScript (JS) Example: HTML DOM Objects – Event – onsubmit JavaScript (JS) Example Purpose: – Illustrates the JavaScript syntax for the onsubmit Event. View Other Attributes and Handlers for DOM Events Prerequistes: Install Visual Web Developer 2008 Syntax: Object.onsubmit=”yourjavascriptcode()” – Allows you to know when submit button is pressed. Restrictions: None Notes: You can build your... [Read More...]
