F # SQL type provider - why aren't all stored procedures provided?

Question

I am trying to access an existing database using type Microsoft.FSharp.Data.TypeProviders.SqlDataConnection. There are some stored procedures that are not provided (but most of them).

I am trying to determine what distinguishes impossible procedures from others - I believe that custom types are one of the reasons why a type situation may occur, but they do not seem to be present here.

For what other reasons might our stored procedures be invalid?

Edit:

I defined the following block as the one that causes the invalid:

      EXEC @intReturn = te_audit_log @action = 'I',
                                     @user_id = @intUserId,
                                     @table_id = 1,
                                     @audit_action = 'A',
                                     @data_id = @intStatus,
                                     @session_guid = @session_guid,
                                     @effective_date = @actual_timedate,
                                     @employee_id = @employee_id

... I think this is because sproc, which is "exec" ed, also has paths that return values ​​from the temp table.

Answer 1

, ( db), . sp_describe_first_result_set FMTONLY

:

sp_describe_first_result_set .

@tsql Transact-SQL. Transact-SQL. , , , Transact-SQL.

@params NULL , , , .

Transact-SQL , , @params.

.

, .

, , , . , , :

, , .

, NULL.

, nullability , nullability NULL.

, , , :

• varchar (a) varchar (a '), a > a.

• varchar (a) varchar (max)

• nvarchar (a) nvarchar (a '), a > a.

• nvarchar (a) - nvarchar (max)

• varbinary (a) varbinary (a '), a > a.

• varbinary (a) varbinary (max)

, , .

, TSQL

SELECT * FROM sys.dm_exec_describe_first_result_set ('[schema].[name]',<params> , 0);