sql-function Questions
4
Solved
I would like to know what's the best way to register a custom SQL function with JPA/Hibernate.
Do I have to go through extending the MysqlInnodb dialect or is there a better way?
Can anyone pleas...
Extinct asked 10/9, 2012 at 7:11
4
Solved
What's the difference between table-valued functions and views? Is there something you can do with 1 that's hard or impossible to do with the other? Or does the difference lie in efficiency?
Arroyo asked 10/2, 2011 at 16:54
7
Solved
I'm looking at MySQL procedures and functions. What is the real difference?
They seem to be similar, but a function has more limitations.
I'm likely wrong, but it seems a procedure can do everythin...
Lalitta asked 19/9, 2010 at 1:43
3
I am trying to create a MySQL function using phpMyAdmin and getting this error.
#1415 - Not allowed to return a result set from a function
The function code is as below:
DELIMITER $$
CREATE FUN...
Corene asked 9/8, 2012 at 9:22
2
Solved
I am working with existing project, and I am found a sql query with sql-function like
SELECT * FROM money WHERE amount = float_convert(0.1);
This Query is Working Properly, But I want to see and e...
Yu asked 6/9, 2014 at 6:38
3
Solved
I have all the SQL files checked into a repo on Azure devops.
I have naming convention that allows me to know which .sql files are used by other .sql files (ex. file creates a view that is used by...
Parachute asked 8/6, 2020 at 12:33
2
Solved
I have the following JSON data :
set @json = N'{
"Book":{
"IssueDate":"02-15-2019"
, "Detail":{
"Type":"Any Type"
, "Author":{
"Name":"Annie"
, "Sex":"Female"
}
}
, "Chapter":[
{
"Sect...
Greig asked 15/2, 2019 at 7:1
12
Solved
How can I achieve the equivalents of SQL's IN and NOT IN?
I have a list with the required values. Here's the scenario:
df = pd.DataFrame({'country': ['US', 'UK', 'Germany', 'China']})
countries_to_...
Bombay asked 13/11, 2013 at 17:11
10
Solved
I am passing a simple query where I am searching for specific rows where OrderID is an even number
SELECT *
FROM Orders
WHERE mod(OrderID,2) = 0;
Error :
Syntax error (missing operator) in ...
Unfold asked 31/1, 2016 at 6:20
3
I am trying to concatenate many columns and separating it with a comma as below:
Column
------
abc
bcd
bgd
abc
Expected output: abc,bcd,bgd
I am using this code:
CREATE FUNCTION concatinate(@P...
Tridentine asked 29/8, 2015 at 11:53
9
Solved
I need to check when function was changed last time. I know how to check creation date (it is in function properties window in SQL Server Management Studio).
I found that in SQL Server 2000 it wasn...
Sugared asked 7/4, 2011 at 9:56
6
Solved
I need to find out if a function exists in a database, so that I can drop it and create it again. It should basically be something like the following code that I use for stored procedures:
IF EXIST...
Oneeyed asked 24/3, 2011 at 12:28
5
Solved
I need to create a function in SQL server that returns daylight savings time start datetime and daylight savings time end datetime.
I've come across a few examples on the web, however they all are...
Raffo asked 1/11, 2013 at 18:20
8
Why can we not execute a stored procedure inside a function when the opposite is possible?
Brundisium asked 24/5, 2010 at 11:3
12
Solved
This is based on a similar question How to Replace Multiple Characters in Access SQL?
I wrote this since sql server 2005 seems to have a limit on replace() function to 19 replacements inside a wh...
Blaisdell asked 16/10, 2009 at 19:38
6
I'm getting the below error for the given function.
Msg 2010, Level 16, State 1, Procedure GetTableFromDelimitedValues, Line 2
Cannot perform alter on 'dbo.GetTableFromDelimitedValues' because it ...
Blue asked 28/1, 2014 at 22:55
2
Solved
I stumbled upon a slump in performance when a simple SQL function is declared STRICT while answering this question.
For demonstration, I created two variants of a function ordering two elements of ...
Chaunce asked 10/12, 2011 at 7:43
1
Solved
I have a simple PostgreSQL function which I aspect should return values into separate columns -115 and 101000005458E6258... but it returns one column where two values are separated by a comma...
Marissamarist asked 25/6, 2020 at 14:7
3
Solved
I am trying to use result of function execution in where clause but with no success:
SELECT clinics.*, distance_between_objects(1, id, 7, 3) AS dist FROM clinics WHERE dist<=1;
gives me:Colum...
Alten asked 23/11, 2017 at 12:49
2
Solved
I need to try and find a free seat on a plane, and then reserve that seat.
I need to return both a value to indicate success or not as well as a seat number. By looking around I've found that func...
Sangria asked 3/5, 2014 at 17:21
8
Solved
Why do Scalar-valued functions seem to cause queries to run cumulatively slower the more times in succession that they are used?
I have this table that was built with data purchased from a 3rd par...
Deina asked 28/4, 2009 at 22:1
2
Solved
Is it possible to use the LEAD or LAG SQL functions from C#?
My preference of method is:
Linq to SQL
Entity Framework
Dynamic Linq
SQLFunctions class
Manual TSQL via a SQLCommand
I know it can...
Ardennes asked 23/5, 2016 at 7:19
2
Solved
In the ETL process, I receive a varchar field, and the length (of the value) is changed from row to row.
I need to keep 5 symbols from the right side of the string.
It means that I need to cut the ...
Grovergroves asked 16/5, 2019 at 7:25
19
Solved
When should I use a function rather than a stored procedure in SQL, and vice versa? What is the purpose of each?
Citole asked 24/7, 2009 at 19:40
1
Solved
In PostgreSQL, what is the difference between a prepared statement and a SQL or PL/pgSQL function, in terms of their purposes, advantages and disadvantages? When shall we use which?
In this very s...
Pitts asked 27/6, 2018 at 0:10
1 Next >
© 2022 - 2024 — McMap. All rights reserved.