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 vote256 views1 answer
Write sql query to show the details start from digit
SQL
5 votes238 views2 answers
Update all rows mysql
SQL
1 vote254 views1 answer
Multiple count in sql
SQL
22 votes266 views3 answers
SQL CHEATSHEET
SQL
1 vote248 views1 answer
Oracle lock user
SQL
8 votes251 views2 answers
Phpmyadmin default password
SQL
3 votes260 views1 answer
Query less than datetime sql
SQL
0 vote245 views1 answer
Mysql workbench primary key
SQL
0 vote274 views1 answer
Typeorm raw sql
SQL
4 votes273 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL