Printing integer variable and string on same line in SQL

Question

Ok so I have searched for an answer to this on Technet  to no avail     I just want to print an integer variable concatenated with two String variables    This is my code  that doesn t run   print  There are      Number     alias combinations did not match a record    It seems like such a basic feature  I couldn t imagine that it is not possible in T-SQL  But if it isn t possible  please just say so  I can t seem to find a straight answer

User · Answer

Numbers have higher precedence than strings so of course the + operators want to convert your strings into numbers before adding.

You could do:

print 'There are ' + CONVERT(varchar(10),@Number) +
      ' alias combinations did not match a record'

or use the (rather limited) formatting facilities of RAISERROR:

RAISERROR('There are %i alias combinations did not match a record',10,1,@Number)
WITH NOWAIT

User · Answer

declare  x INT   1    Declares an integer variable named  quot x quot  with the value of 1         PRINT  There are     CAST  x AS VARCHAR      alias combinations did not match a record     Prints a string concatenated with x casted as a varchar

User · Answer

You can t combine a character string and numeric string   You need to convert the number to a string using either CONVERT or CAST   For example   print  There are     cast  Number as varchar      alias combinations did not match a record    or  print  There are     convert varchar  Number      alias combinations did not match a record

User · Answer

Double check if you have set and initial value for int and decimal values to be printed    This sample is printing an empty line  declare  Number INT print  The number is       CONVERT VARCHAR   Number    And this sample is printing -  The number is   1  declare  Number INT   1 print  The number is       CONVERT VARCHAR   Number

User · Answer

You may try this one   declare  Number INT   5                             print  There are     CONVERT VARCHAR   Number      alias combinations did not match a record

[sql] Printing integer variable and string on same line in SQL

Examples related to sql

Examples related to sql-server

Examples related to tsql