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

4 votes185 views1 answer
Mysql insert from local csv
SQL
0 vote191 views1 answer
Sql query for getting data with join and count
SQL
1 vote142 views1 answer
Postgres reset auto increment
SQL
1 vote217 views1 answer
Increasing font and zooming in mysql workbench
SQL
15 votes178 views7 answers
MYSQL
SQL
24 votes190 views5 answers
Sql server insert into select
SQL
3 votes198 views1 answer
Sql print all names that start with a given letter
SQL
5 votes241 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote186 views1 answer
Oracle archivelog usage
SQL
1 vote193 views1 answer
What is in condition in sql
SQL