View Questions by Category
There are no sub categories
Category » Microsoft SQL Server 2005 Express
There were 3 questions found in this category:
How do I concatenate two columns in Microsoft SQL Server 2005?
Use + to concatenate two columns. For example: SELECT DeviceMgf.MfgName + ' ' + DeviceModel.ModelName AS Device, DeviceModel.ModelIDFROM DeviceMfg INNER JOIN DeviceModel ON DeviceMfg.MfgID = DeviceModel.MfgIDORDER BY Device Adding + ' ' + will concatenate the two columns and put a space in bet ...
- What are the Microsoft SQL Server 2005 Boolean operators?
Operator Description AND Evaluates as true if both of the criteria are true. OR Evaluates as true if either of the criteria is true. NOT Used with the above operators. It negates the value of the criteria (e.g. AND NOT, OR NOT).
- What are the Microsoft SQL Server 2005 comparison operators?
Operator Definition = Equal to. <> Not equal to. != Not equal to. This operator is the same as the <> operator. > Greater than. >= Greater than or equal to. !> Not greater than. < Less than. <= Less than or equal to. !< Not ...