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

2 votes162 views1 answer
Create table with primary key
SQL
7 votes204 views3 answers
Restore postgres database from sql file
SQL
1 vote177 views1 answer
Tsql find foreign key references
SQL
0 vote169 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
1 vote179 views1 answer
Sql week commencing date
SQL
1 vote152 views1 answer
Avg mysql
SQL
0 vote173 views1 answer
Utiliser sql ligne de commande
SQL
1 vote165 views1 answer
What is int in mysql
SQL
0 vote182 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
1 vote176 views1 answer
Mysql show queries running
SQL