Sql function

Create Function Fn_ToplamaYap(@sayi1 int,@sayi2 int)
Returns int
As
Begin
Declare @toplam int
Set @toplam = @sayi1+ @sayi2
return @toplam
End

Create function syntax sql server

CREATE FUNCTION Fact (@parameter datatype)
RETURNS returndatatype
AS
BEGIN
--sql statements
    RETURN --whatever you want to return but of returndatatype from above
END

Function in sql

CREATE [OR ALTER] FUNCTION <FNAME> (@<PARAMETER NAME1><DATATYPE>[SIZE]
RETURNS <return PARAMETER / ATTRIBUTE /VARIABLE DATATYPE>
AS
BEGIN
<FUNCTION BODY / STATEMENTS>
RETURN <return PARAMETER/ATTRIBUTE/VARIABLE NAME>
END

Similar codes

0 vote301 views1 answer
Oracle search in date columns
SQL
2 votes328 views2 answers
Postgresql search all tables for column name
SQL
0 vote320 views1 answer
Date on SQL
SQL
1 vote340 views4 answers
Get week day from date in sql
SQL
0 vote351 views1 answer
Gcloud sql list databases
SQL
0 vote325 views1 answer
Sql where part of string match
SQL
16 votes328 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
56 votes587 views5 answers
Psql create user
SQL
0 vote263 views1 answer
Online sql compiler
SQL
3 votes314 views3 answers
Mysql order by list
SQL