Top "Sql-function" questions

A function defined in a relational database system.

SQL date format convert? [dd.mm.yy to YYYY-MM-DD]

is there mySQL function to convert a date from format dd.mm.yy to YYYY-MM-DD? for example, 03.09.13 -> 2013-09…

mysql sql date format sql-function
How do I create a SQL Server function to return an int?

I'm trying to create a SQL Function that tests whether a parameter starts with a certain term or contains the …

sql sql-server tsql sql-function
Return multiple values from PL/SQL Function

I need to try and find a free seat on a plane, and then reserve that seat. I need to …

oracle plsql sql-function
divide the value of a column by another column

I want to divide a value of a column by the value of another column and display the result as …

sql sql-function
How to create Daylight Savings time Start and End function in SQL Server

I need to create a function in SQL server that returns daylight savings time start datetime and daylight savings time …

sql sql-server-2008 dst sql-function
INNER JOIN with Table-Valued Function not working

I have a table valued function that returns a table. When I try to JOIN the table-valued function with another …

sql-server function tsql sql-function
Why MySQL is giving error "Not allowed to return a result set from a function"?

I am trying to create a MySQL function using phpMyAdmin and getting this error. #1415 - Not allowed to return a …

mysql sql sql-function
pass parameter in table valued function using select statement

I have created a table valued return function which returns me a table . here is call of my function as …

sql sql-server sql-server-2008 tsql sql-function
Why do SQL Server Scalar-valued functions get slower?

Why do Scalar-valued functions seem to cause queries to run cumulatively slower the more times in succession that they are …

sql sql-server tsql sql-server-2005 sql-function
How to call a recursive function in sql server

I have a table as follows cat_id Cat_Name Main_Cat_Id 1 veg null 2 main course 1 3 starter 1 4 Indian 2 5 mexican 2 6 …

sql-server sql-server-2008 sql-function