Operators – SQL Server Syntax Example: Operators – T-SQL Example

Putting the Pieces of .NET Together - 8 Part Video Series By Wade Harvey
Introduction
Videos 1-4	1. Servers (3 minutes)	2. .NET Framework (10 minutes)	3. Security (8 minutes)	4. Monitoring Tools (10 minutes)
Videos 5-8	5. Web Servers (6 minutes)	6. SQL Server (6 minutes)	7. Software Develop Tools (10 minutes)	8. Languages (2 minutes)
Download PDF	Putting the Pieces of .NET Together - 48-page PDF

Operators – SQL Server Syntax Example: Operators – T-SQL Example

Purpose: – Illustrates the SQL Server syntax for operators.

SYNTAX:

SELECT [ ALL | DISTINCT ]
[TOP ( expression ) [PERCENT] [ WITH TIES ] ]
column_list
[ INTO new_table ]
[ FROM { table_source } [ ,...n ] ]
[ WHERE expression1 operator expression2
[ GROUP BY ]
[ HAVING search_condition ]
[ ORDER BY order_expression [ ASC | DESC ]

PURPOSE:
Operators represent an action (operation) to be performed on one or more expressions

 

Here is a table of the various types of operators:

Arithmetic Operators	mathematical operations
Assignment Operator	assignment operations
Bitwise Operators	bit manipulations
Comparison Operators	compare equality of two expressions
Logical Operators	test for truth of some condition
Scope Resolution Operator	:: provides access to static members
String Concatenation Operator	+ is used for string concatenation
Unary Operators	+ (positive), – negative, ~(bitwise not)

 

Code Sample for Opearators:

 T-SQL | 
 copy code |
?
 
 
/* Operators example from http://idealprogrammer.com 
 
 PURPOSE: Operator is a symbol specifying an action that will take place on one or
          more expressions
 
 SYNTAX: 
 
 [expression1] operator expression2
 
 Here is a table of the various types of operators:
 
 Arithmetic Operators -          mathematical operations
 Assignment Operator -           assignment operations
 Bitwise Operators -             bit manipulations
 Comparison Operators -          compare equality of two expressions
 Logical Operators -             test for truth of some condition
 Scope Resolution Operator -     :: provides access to static members 
                                 of a compound data type
 String Concatenation Operator - + is used for string concatenation 
 Unary Operators -               + (positive), - negative, ~(bitwise not)
 
 
 
 
 
 
 SELECT [ ALL | DISTINCT ] 
			[TOP ( expression ) [PERCENT] [ WITH TIES ] ] 
			 column_list  
			[ INTO new_table ] 
			[ FROM { table_source } [ ,...n ] ] 
			[ WHERE expression1 operator expression2] 
			[ GROUP BY ] 
			[ HAVING  search_condition  ] 
			[ ORDER BY  order_expression [ ASC | DESC ] ] 
*/
 
 
CREATE TABLE people(
     ID          INT,
     firstname   VARCHAR (20),
     lastname    VARCHAR (20),
     statecode   VARCHAR (2),
     alive       BIT,
     height      INT )
 GO
 
 
 
 
 INSERT INTO people (ID, firstname, lastname, statecode, alive) --height is null 
 VALUES (1,  'Paul', 'Revere', 'AL', 0)
 GO
 
 INSERT INTO people (ID, firstname, lastname, statecode, alive, height) 
 VALUES (2,  'Pat', 'Lennon', 'NY', 0, 69)
 GO
 
 INSERT INTO people (ID, firstname, lastname, statecode, alive, height)
 VALUES (3,  'Peter', 'Martin', 'NY', 1, 75)
 GO
 
 INSERT INTO people (ID, firstname, lastname, statecode, alive, height)
 VALUES (4,  'George', 'Washington', 'VA', 0, 75)
 GO
 
 
 
 -- Select entire table
 SELECT 'Entire Table', * FROM people
 
 -- 1. Example of using comparison operator =
 
 SELECT 'Example #1' AS Example, firstname, lastname, height 
  FROM people p
  WHERE firstname = 'Paul'
 
 GO
 
 -- 2. Example of logical operator AND
 
 SELECT 'Example #2' AS Example, firstname, lastname, height 
  FROM people p
  WHERE firstname = 'Paul' AND lastname = 'Revere'
 
 GO
 
 -- 3. Example of using + for string concatenation
 
 
 SELECT 'Example #3' AS Example, firstname + ' ' + lastname AS Fullname, height 
  FROM people p
 
 
 GO
 
 
 
 
 
 
 
 DROP TABLE people;
 
 GO
 
 
 

Sample Output for Operators Example

Related posts:

1. Logical Operators – SQL Server Syntax Example: Logical Operators – T-SQL Example Logical Operators - SQL Server Syntax Example: Logical Operators -...
2. Operator Precedence – SQL Server Syntax Example: Operator Precedence – T-SQL Example Operator Precedence - SQL Server Syntax Example: Operator Precedence -...
3. Or Operator – SQL Server Syntax Example: Or Operator – T-SQL Example Or Operator - SQL Server Syntax Example: Or Operator -...
4. LIKE – SQL Server Syntax Example: LIKE – T-SQL Example LIKE - SQL Server Syntax Example: LIKE - T-SQL Example...
5. NULL – SQL Server Syntax Example: NULL – T-SQL Example NULL - SQL Server Syntax Example: NULL - T-SQL Example...

Related posts brought to you by Yet Another Related Posts Plugin.