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?
请先登录再写评论。
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
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.
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