how to get a value from your database them print it out to your screen sql code example

Example: Cast for print sql

declare @x INT = 1 

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