Skip to content
Advertisement

Printing integer variable and string on same line in SQL

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.

Advertisement

Answer

declare @x INT = 1 /* Declares an integer variable named "x" 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 contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement