Top "Sql-function" questions

MySQL Function to add a number of working days to a DATETIME

I need a MySQL Function that will allow me to pass a number of working days (Monday - Friday) and …

mysql sql sql-function

SQL: Last_Value() returns wrong result (but First_Value() works fine)

I have a table in SQL Server 2012 as the snapshot shows: Then I'm using Last_Value() and First Value to …

sql sql-server sql-server-2012 sql-function

Registering a SQL function with JPA and Hibernate

I would like to know what's the best way to register a custom SQL function with JPA/Hibernate. Do I …

java spring hibernate sql-function dialect

Convert stored procedure to table-valued query

I have this procedure ALTER PROCEDURE [dbo].GetHerdByUserProc(@user int) As begin Declare @GroupId uniqueidentifier, @UserTrade bit Set @GroupId = (select …

sql sql-server-2008 stored-procedures stored-functions sql-function

Are execution plan for functions cached in SQL server?

Can any body help me in understanding if the execution plan for functions cached in SQL server? Any online resource …

sql-server function tsql sql-execution-plan sql-function