Post reply

Results in my new query window

  • April 23, 2015 at 11:59 am

    #297352

    Guys I have looked all over the web for this and maybe its the way im asking the question but I need help. Can anyone tell me when i open a new query window in microsoft sql server management studio 2012 and create the query when i hit execute how do i get the full results to display at the bottom of the window instead of it just telling me it completed successfully how do i actually view the real results? I would really appreciate help on this thanks

    here is a pic i circled what i was trying to explain about seeing the actual results of the query instead of what im getting

  • April 23, 2015 at 12:15 pm

    #1793089

    Well, that is the result of that particular query. You inserted a single row of data into a table and SQL Server reported 1 row inserted.

    If you had surrounded the insert query with SET NOCOUNT ON and SET NOCOUNT OFF, you wouldn't have seen that even.

  • April 24, 2015 at 6:28 am

    #1793236

    For an insert query, those are the full results. You're seeing exactly what you should. You inserted a row. It was completed successfully. An insert doesn't return data.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply