I'm using a simple print statement in a stored procedure in SQL Server Express 2012, and it is my understanding that the statement is supposed to return printed text to the user. I cannot see the statement being returned, because it isn't popping up and I don't know where to look. Where should I see the what is supposed to be printed after I execute the stored procedure in SQL Management Studio?
Here is my stored procedure: CREATE PROCEDURE pr_Names @VarPrice money AS BEGIN -- The print statement returns text to the user PRINT 'Products less than ' + CAST(@VarPrice AS varchar(10)); -- A second statement starts here SELECT ProductName, Price FROM vw_Names WHERE Price < @varPrice; END GO
Here is my execute statement: EXECUTE pr_Names 10.00; GO