Hello,
I'm using Microsoft SQL Server Database as a provider.
I want to get results from SQL server stored procedure, so I try to use "Custom SQL query" option and write like this:
EXECUTE [dbo].[NameOfProcedure]
When I press "View Data in Grid", it runs without errors, but returns no results. Maybe I am writing something in wrong syntax? Because when I run this procedure in SSMS, I get results.