How can I filter words in SQL using a function? - Stack Overflow
How can I filter words in SQL using a function? I'm having a hard time if I explain it, so I'm giving an example: ID WebsiteName 1 www.yahoo.com 2 www.google.com 3 www.youtube.com What I want …
sql - MySQL CREATE FUNCTION Syntax - Stack Overflow
Jul 19, 2011 · I am trying to create a function in MySQL: Here is the SQL code: CREATE FUNCTION F_Dist3D (x1 decimal, y1 decimal) RETURNS decimal DETERMINISTIC BEGIN DECLARE dist …
Define a function and use it in a SQL-Query - Stack Overflow
Sep 6, 2017 · 4 Yes, SQL functions are easy to create. But you have to understand the 3 different types of functions in SQL: 1) Scalar functions: -- return a single value. 2) Table based functions: -- returns …
sql - Can I create a One-Time-Use Function in a Script or Stored ...
In SQL Server 2005, is there a concept of a one-time-use, or local function declared inside of a SQL script or Stored Procedure? I'd like to abstract away some complexity in a script I'm writing, but it …
sql - Create a function in PostgreSQL - Stack Overflow
Oct 11, 2021 · I am not sure how the CREATE FUNCTION statement works in PostgreSQL. I want to define a function (just for entertainment) such that given a number n, it prints asterisks starting from 1 …
How can I create a function in SQL with 2 parameters?
Sep 3, 2018 · 2 I'm trying to create a function that SUMs the total number of minutes of actual duration for videos with a Finished status given a UserID as a parameter. This is what I have so far but I can't …
T-SQL - function with default parameters - Stack Overflow
The answer that states, you MUST supply all parameters for user defined functions is the correct answer. AS of 2022, it doesn't matter if the function is given a default parameter or not, you MUST …
Function vs. Stored Procedure in SQL Server - Stack Overflow
When should I use a function rather than a stored procedure in SQL, and vice versa? What is the purpose of each?
tsql returning a table from a function or store procedure
This is more of a syntax question I'm trying to write a store procedure or function that I can embed into a query such as: select * from MyBigProcOrFunction I'm trying to define a tabular function...
How to create user defined function using variable in snowflake?
Sep 12, 2022 · I am trying to create a UDF to get full_name in snowflake with the below code: CREATE OR REPLACE FUNCTION LASTNAMEFIRST (LAST_NAME char(100),FIRST_NAME char(100)) …