This topic has not yet been rated - Rate this topic

Operators (Transact-SQL)

SQL Server 2008

An operator is a symbol specifying an action that is performed on one or more expressions. The following tables lists the operator categories that SQL Server uses.

Arithmetic Operators	Logical Operators
Assignment Operator	Scope Resolution Operator
Bitwise Operators	String Concatenation Operator
Comparison Operators	Unary Operators

Reference

Operator Precedence (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ

Missing Sub-Topic "Operator Precedence"

Although not listed on this page; there is a sub-topic called "Operator Precedence" (http://msdn.microsoft.com/en-us/library/ms190276.aspx). This sub-topic lists the order of precedence used when 2 or more of the "Operators" are used in a complex expression. This is especially useful when using multiple operators that do not belong to the same operator category in a complex expression; the "Operator Precedence" may impact the resulting value.

Microsoft Connect "Suggestion" submitted: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=506568#details

History

10/30/2009
DBA James

10/30/2009
DBA James