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

How to insert SELECT LISTAGG values to varchar variable

I am writing an Oracle user defined function. How can I insert listtagg values Pears, Oranges, Bananas, Apples into a …

oracle plsql oracle11g sql-function listagg

Very Slow SQL Server Query using Functions

This sort of follows on from a previous question: SQL Server Query time out depending on Where Clause In which …

sql sql-server performance tsql sql-function

Concatenating distinct column values in SQL Server

I am trying to concatenate many columns and separating it with a comma as below: Column ------ abc bcd bgd …

sql-server sql-server-2008 sql-function