Hi,
is it true that Functions (Scalar Functions, Table Valued Function, Inline Table Valued Functions) are not recognized by the SQL Server Service (SourceCode.SmartObjects.Services.SQL.SqlServerService)?
We have a lot of them (~1.500) on our MS SQL 2016 SQL server.
The UDFs are not even mentioned in the documentation:
What do you recommend to integrate MS SQL Functions?
Kind regards,
Stephan
Hello Stephan,
I am unsure if K2 integrates directly with those. I know that temp tables and the like are not supported by K2 as smartobjects, but you can use Stored Procs to pull back data from multiple sources.
Hi,
I'm not sure if this is going to be possible without building a SQL procedure to call the function(s) since these are not really SQL objects that K2 can see.
https://stackoverflow.com/questions/33449/can-you-call-a-webservice-from-tsql-code
Hi,
i see the necessity to clarify my question.
I am not talking about CLR Functions. I am talking about normal sql functions:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-function-transact-sql
They are internal sql objects that are accessible like procudures, type IF, TF, FN, see example query below.
One uses functions because you can combine tables and functions with JOIN clauses. This not possible with Stored Procedures.
Kind regards,
Stephan
SELECT type_desc, type, COUNT(*)
FROM sys.objects
GROUP BY type_desc, type
ORDER BY COUNT(*) DESC
| type_desc | type | # |
| SYSTEM_TABLE | S | 69 |
| DEFAULT_CONSTRAINT | D | 64 |
| SQL_INLINE_TABLE_VALUED_FUNCTION | IF | 25 |
| SQL_STORED_PROCEDURE | P | 16 |
| USER_TABLE | U | 13 |
| VIEW | V | 12 |
| INTERNAL_TABLE | IT | 10 |
| PRIMARY_KEY_CONSTRAINT | PK | 8 |
| SQL_TABLE_VALUED_FUNCTION | TF | 5 |
| SERVICE_QUEUE | SQ | 3 |
| TYPE_TABLE | TT | 1 |
| SQL_SCALAR_FUNCTION | FN | 1 |
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.