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

10 votes115 views4 answers
Drop primary key
SQL
0 vote117 views1 answer
Vbscript connect mssql
SQL
0 vote123 views1 answer
Allow external access to mysql
SQL
1 vote109 views1 answer
Launch sql script from docker in mysql
SQL
15 votes119 views4 answers
Export mysql db using command line
SQL
0 vote117 views1 answer
Print boolean in plsql
SQL
8 votes131 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote119 views1 answer
Renommer schema sql
SQL
3 votes150 views3 answers
List columns in table postgres
SQL
0 vote131 views1 answer
Create query in where clasue
SQL