MSSQL Data From Stored Procedure [DONE]

[danielhitch]

It would be fantastic to have the facility to fetch data from stored procedure directly in EasyMorph.

At present, I am having to create a series of holding tables for the data from the executed stored procedure.

[dgudkov]

Hi Daniel,

you can fetch data directly from stored procedures using custom SQL in queries. See below:

More than that -- it is possible to use EasyMorph project parameters to specify arguments of stored procedures. For example, in the statement above, the argument could be passed via a project parameter.

EXEC dbo.uspGetEmployeeManagers {ParamID};

[rebmanna]

Hi,

is it also possible to call a stored procedure or function via postgresql? (Driver is jdbc)
Here an example via DBVisualizer vs. EasyMorph.
The same call returns an syntax-error in Easymorph.

best regards,

Adrian

[dgudkov]

DBVisualizer's syntax is not standard.

Use the standard syntax:

4.3. Calling Functions

CREATE PROCEDURE

Note that EasyMorph just sends whatever text you entered to the ODBC driver verbatim. It doesn't do any own syntax checks. If there is a syntax error -- then this error is produced by the ODBC driver, not EasyMorph.

[rebmanna]

Hi Dmitry,
it works great!
Returns just one columns (not a table) but with this i can work.

Very very cool!!!
Thanks a lot!

[dgudkov]

Good

Try this syntax to obtain the full table:

SELECT * FROM admin_dwh.database_get_fieldcatalog()

[rebmanna]

works of Course