Forum

Hello Timofey.

I need to call from 1C a stored procedure form SQL SERVER and get the result.

Any idea on how to do this?

Thanks.

Hello, Marius Gidu.

You can use External data sources for this. There is an example in the Tabular Section, ValueTable, FormDataCollection Vs SpreadSheetDocument topic.
The difference is that in your case you need to add a stored procedure definition (see the attached screenshot).

To execute the stored procedure you can use the following script:

ExternalDataSources.StoredProcedure.StoredProcedure(parameter1, parameter2, ...)

Thanks. But my return type is none of the type in the Type field.

How i can do this entirely from code.

If you want to get a table as a result, it is better to create a view or a table with precalculated data, depending on the data load.

Please can you give a complete example of this?

Thanks.

Marius Gidu, the view is created on SQL level. For example, in MS SQL

CREATE VIEW view_name AS 
SELECT table.id, table.value, ...
FROM some_table table