Top "Sql-function" questions

A function defined in a relational database system.

SQL NOT IN Function

Iam trying to insert a record and i want to check that it is not already present in the table. …

sql-function sql-in
Error 6046: Unable to generate function import return type of the store function

I have a scalar-valued function in my sql database. I receive this error when importing this function into Entity Framework …

linq entity-framework sql-function
What is the difference between prepared statements and SQL or PL/pgSQL functions, in terms of their purpose?

In PostgreSQL, what is the difference between a prepared statement and a SQL or PL/pgSQL function, in terms of …

sql postgresql prepared-statement plpgsql sql-function
SQL Server execute (sp_executesql ) command in SQL function

I created a function in SQL Server to execute a dynamic SQL query and return a value. I'm getting error …

sql sql-server stored-procedures sql-function
Can I run an HTTP GET directly in SQL under MySQL?

I'd love to do this: UPDATE table SET blobCol = HTTPGET(urlCol) WHERE whatever LIMIT n; Is there code available to …

mysql http-get sql-function
EF 6.1 Scalar-Valued Functions Database First

My application is c# MVC5, using EF 6.1. Imported tables and functions using Database First. I can see the function in …

c# asp.net-mvc entity-framework sql-function
SQL function return-type: TABLE vs SETOF records

What's the difference between a function that returns TABLE vs SETOF records, all else equal. CREATE FUNCTION events_by_type_1(…

sql postgresql return-type sql-function sql-types
SQL SERVER - Problems with COALESCE() function

I have this SQL function which is wrapped by a stored procedure: ALTER FUNCTION dbo.GetObjList ( @filterUID int = NULL, @filterSID …

sql-server coalesce sql-function
Alter SQL Function Referenced by Computed Column

If you set up a table's column to be a computed column whose Formula calls a Function, it becomes a …

sql-server-2005 calculated-columns sql-function non-deterministic
Passing parameters to a SQL view

I have a SQL view, and I want to filter it using parameters passed to it. I was thinking about …

sql-server stored-procedures sql-function