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

6 votes173 views4 answers
How to remove unique key in mysql
SQL
5 votes181 views4 answers
Upload database mysql command line
SQL
21 votes172 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
2 votes176 views1 answer
Sql server: select column values as comma separated string
SQL
1 vote161 views1 answer
Encrypt password postgresql
SQL
0 vote167 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
3 votes171 views1 answer
Convert sqlite table to pandas dataframe
SQL
4 votes169 views1 answer
Change nls_date_format
SQL
0 vote160 views1 answer
Trigger value from maltiple table to single table mysql
SQL
1 vote176 views1 answer
How to change owner in postgres
SQL