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 vote156 views1 answer
How to print some string in mysql
SQL
0 vote151 views1 answer
Access mysql database docker container shell
SQL
-1 vote146 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote146 views1 answer
Mysql repair a table
SQL
0 vote147 views1 answer
Typeorm raw sql
SQL
0 vote115 views1 answer
Mysql insert with foreign key
SQL
2 votes133 views1 answer
Can you use a where clause for a child query
SQL
0 vote162 views2 answers
Amazon linux postgresql client
SQL
0 vote149 views1 answer
Renombrar tabla mysql
SQL
0 vote158 views1 answer
Reset keys in sql
SQL