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 vote131 views4 answers
Mysql count table rows
SQL
0 vote147 views1 answer
Mysql error 1251
SQL
3 votes143 views3 answers
Postgresql random number
SQL
0 vote174 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote174 views1 answer
Linux upload database to mysql
SQL
3 votes143 views2 answers
Truncate all tables
SQL
3 votes124 views1 answer
Oracle failed login attempts
SQL
22 votes174 views4 answers
Mysql format date
SQL
0 vote167 views1 answer
Alter owner in PostgreSQL
SQL
2 votes135 views3 answers
Write sql query to find the second highest salary of employee
SQL