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

Get 5 Hours of FREE PREMIUM Videos:

LearnVisualStudio.NET Free Preview

LearnVisualStudio Premium Videos

dotNetVideos Premium Video Catalog

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:

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. NULL – SQL Server Syntax Example: NULL – T-SQL Example NULL - SQL Server Syntax Example: NULL - T-SQL Example...
3. NOT – SQL Server Syntax Example: NOT – T-SQL Example NOT - SQL Server Syntax Example: NOT - T-SQL Example...
4. IN – SQL Server Syntax Example: IN – T-SQL Example IN - SQL Server Syntax Example: IN - T-SQL Example...
5. LIKE – SQL Server Syntax Example: LIKE – T-SQL Example LIKE - SQL Server Syntax Example: LIKE - T-SQL Example...

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