Answers for "sql print string"

Cast for print sql

declare @x INT = 1 

PRINT 'There are ' + CAST(@x AS VARCHAR) + ' alias combinations did not match a record'

sql query print strings and int

print 'There are ' + cast(@Number as varchar) + ' alias combinations did not match a record'

sql query print strings and int

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