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 vote242 views1 answer
Select new table sql
SQL
1 vote223 views2 answers
Mysql error 1215
SQL
1 vote212 views1 answer
Mysql pretty date format
SQL
0 vote236 views2 answers
Mysql insert into multiple tables
SQL
0 vote221 views2 answers
Sql use not in
SQL
0 vote209 views1 answer
Show create table in postgresql
SQL
0 vote226 views1 answer
Mysql where in maintain order
SQL
1 vote212 views1 answer
Give a column name to values generated from case statement in sql
SQL
1 vote216 views1 answer
Postgres delete from where date is greater than specific date
SQL
7 votes206 views3 answers
How to check table name in current database sql
SQL