Function Database

[Shashi123 (Shashi)]

How can i call database function in UiPath

[J0ska]

@Shashi123

database function

Do you mean stored procedure?

Cheers

[Shashi123 (Shashi)]

No Stored procedure i get it. But i want to call a function using uipath.

[J0ska]

Hmmm
Could you give an example of “database function”?

Cheers

[Shashi123 (Shashi)]

By database functions means SQL functions. Example: This is an example i have picked from google.
CREATE FUNCTION sales.udfNetSale(
@quantity INT,
@list_price DEC(10,2),
@discount DEC(4,2)
)
RETURNS DEC(10,2)
AS
BEGIN
RETURN @quantity * @list_price * (1 - @discount);
END;

[J0ska]

I see. You can call your custom function like a built-in function in SELECT statement

SELECT
sales.udfNetSale(10,100,0.1) net_sale

Cheers