Running a script against SQL Server

It is common practice in the SQL Server world to have scripts of commands that finish with a SELECT statement. When run in SQL Server Management Studio these execute and then display the results of the final SELECT statement in the console window. When I try this in DataGrip all I see is a series of information messages. Is there a way to change the behaviour of the application to show the results console?

3 comments
Comment actions Permalink

What does your output console look like? I have attached a screen grab of mine after running a generic select statement. There are two areas. "OUTPUT" and "<user>.<table>"

Do you see both?



Attachment(s):
output_console_example.PNG
0
Comment actions Permalink

Nathan,

I see those when I execute a single SQL statement. But when I have a file with a series of statements and then execute the whole file I don't see the output tab from the final statement - which is what SQL Server Management Studio does.

0
Comment actions Permalink

Hello Andrew,
It is not yet possible to disaply all select result in sql results console for such statements, please vote and follow this request: https://youtrack.jetbrains.com/issue/DBE-2016

0

Please sign in to leave a comment.