Function in sql

Sql function

Create Function Fn_ToplamaYap(@sayi1 int,@sayi2 int)
Returns int
As
Begin
Declare @toplam int
Set @toplam = @sayi1+ @sayi2
return @toplam
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

15 votes175 views4 answers
Sql update from select
SQL
1 vote168 views1 answer
Calculate age in sql postgresql
SQL
2 votes181 views1 answer
Mysql change data type of column
SQL
0 vote155 views1 answer
Heavy table in mysql
SQL
0 vote164 views1 answer
How to convert DateTime to VarChar SQL
SQL
5 votes167 views1 answer
Ignore duplicate rows in sqlite
SQL
2 votes155 views2 answers
Select multiple tables mysql
SQL
2 votes170 views2 answers
How to check database username and password in postgresql
SQL
0 vote170 views1 answer
How many columns can be used for creating index?
SQL
3 votes180 views1 answer
Where id is in list sql
SQL