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 votes300 views2 answers
Install postgresql
SQL
1 vote278 views1 answer
Apex run 404
SQL
0 vote287 views2 answers
Identity column in sql server
SQL
0 vote293 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote269 views1 answer
Oracle last connection
SQL
0 vote262 views1 answer
Sql min
SQL
0 vote283 views1 answer
Postgres enumerated type
SQL
0 vote338 views1 answer
Sql alternative to max statement
SQL
2 votes312 views3 answers
How do I add a user to a postgres database? cli
SQL
1 vote280 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL