BUG: DocErr: Books Online Missing Concatenation Operator (+)

MORE INFORMATION

The following are examples of where the concatention operator is missing in "Books Online":

1. In the "Database Developer's Companion," Chapter 4, Using Built-in Functions, String Functions, the String functions section, and then the example:

         SELECT 'The price is '  CONVERT(varchar(12), price)
         FROM titles
         WHERE price > 10.00
   						

2. In the "Database Developer's Companion," Chapter 4, Using Built-in Functions, String Functions, in the Concatenation section.
3. In the "Transact-SQL Reference," F, Functions chapter, Convert Function section, and then the example:
   

         SELECT 'The date is '  CONVERT(varchar(12), getdate())
    
   						

4. In the "Administrator's Companion," Part 8, Chapter 24 in the sections on sp_resetstatus and sp_marksuspect (as reported in BUG 12099).

However, at some places in "Books Online," the concatenation operator is present.

For example:

1. In the "Transact-SQL Reference," P, Print, in the example:
   

      DECLARE @returnmessage varchar(255)
      SELECT @returnmessage = 'This record was updated on ' +
         RTRIM(CONVERT(char(30), GETDATE())) + '.'
      PRINT @returnmessage
   
   						

NOTE: The printed documentation set for SQL Server 6.0 is fine, it is not missing the concatenation operator.