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 vote316 views1 answer
C# sql transaction multiple connections
SQL
0 vote280 views1 answer
Print intervals of 15 minutes in sql query
SQL
1 vote235 views2 answers
Show sql logs in spring boot
SQL
0 vote281 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote274 views1 answer
Access mysql database docker container shell
SQL
0 vote297 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote257 views1 answer
Sort by last two number sql
SQL
0 vote275 views1 answer
Psql select * from table
SQL
0 vote307 views2 answers
Mysql missin expression near on
SQL
0 vote291 views1 answer
Sql put two columns into one
SQL