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 vote225 views1 answer
Jooq replace
SQL
0 vote175 views1 answer
Amount of entries in a table psql
SQL
0 vote179 views1 answer
Mysql return column names when table is empty
SQL
5 votes198 views3 answers
Select tables from mysql database
SQL
4 votes255 views4 answers
Update select mysql
SQL
0 vote210 views1 answer
Select true if exists on another table or false sqlserver
SQL
14 votes178 views4 answers
Import database through command line
SQL
0 vote228 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote171 views1 answer
Sqlcmd no headers
SQL
0 vote175 views1 answer
Oracle search in date columns
SQL