Function in sql

Sql function

Create Function Fn_ToplamaYap(@sayi1 int,@sayi2 int)
Returns int
As
Begin
Declare @toplam int
Set @toplam = @sayi1+ @sayi2
return @toplam
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

1 vote153 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote127 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote156 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
8 votes139 views2 answers
Safe update mode in mysql
SQL
0 vote132 views1 answer
How to add session data into mysql database from button
SQL
37 votes130 views3 answers
Postgresql insert column
SQL
0 vote121 views1 answer
Add plugins to mysql workbench
SQL
2 votes127 views1 answer
Match in sql server
SQL
3 votes137 views3 answers
Postgresql random number
SQL
0 vote127 views1 answer
Group_concat only returns one row
SQL