Results of a query not showing up. says "Commands completed successfully"

Asked Feb 05 '18 at 16:59

Active Feb 05 '18 at 16:59

Viewed 952 times

I have a small query that needs print the results in the results pane. The query runs fine without any errors. But I don't see the output of the query in results pane. All other select statements show the results in the results pane. Just this query is not showing up the results. In the query option-->Query Results-->SQL sever--> Default destination to "Results to Grid" is already selected.

DECLARE @Start int
SET @Start = 45

WHILE (@Start <=5)
BEGIN
     PRINT CHAR(@Start)
    SET @Start = @Start+1
 END

asked Feb 05 '18 at 16:59

SQLServerNewBie2

1

Because initial value of @Start (45) bigger than 5 – Serkan Arslan Feb 05 '18 at 17:05
Thank You. Typo from my side. I wanted to put 55 and instead type 5. – SQLServerNewBie2 Feb 05 '18 at 18:07

Results of a query not showing up. says "Commands completed successfully"

0 Answers0