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

35 votes212 views6 answers
Postgres
SQL
0 vote287 views1 answer
Mysql readable output
SQL
1 vote197 views1 answer
Postgresql delete cascade
SQL
0 vote240 views1 answer
Grouping by email domain mysql
SQL
1 vote260 views1 answer
Oracle grant select on schema
SQL
1 vote204 views1 answer
How to unlock table in mysql
SQL
0 vote280 views1 answer
Drop all data from tables
SQL
1 vote190 views1 answer
How to select random rows from table
SQL
0 vote231 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote233 views1 answer
Sql server beginning of month
SQL