User Defined Scalar Functions in sql

User Defined Scalar Functions in sql.

---User Defined function
--Scalar Functions
--Table Valued Function
-- inline table valued function
-- Multi statement table valued function


--Scalar Functions
--The return type of a scalar function is any data type except text, ntext, image, cursor and timestamp.
--Scalar functions can be use in a WHERE clause of the SQL Query.

create Table Customer
(
CustId int,
Name Varchar(100),
DOB date
)

Insert into Customer values(1,'Arun','1995-08-21')
Insert into Customer values(2,'Sara','2001-12-05')
Insert into Customer values(3,'Haris','1991-03-30')
Insert into Customer values(4,'Peter','1998-06-15')
Insert into Customer values(5,'Kumar','1985-11-07')

--Calculate Age of customer using scalar function

select * from Customer

--create function/Alter function for create or alter a function
create function fn_calculateAge
(
@DOB date
)
returns int
as
begin
declare @age int
select @age=DATEDIFF(year,@DOB,getdate())
return @age
end



--select statement just passing the column of DOB

select *,dbo.fn_calculateAge(DOB) as Age from Customer

--where clause using for filter data

select *,dbo.fn_calculateAge(DOB) as Age from Customer
where dbo.fn_calculateAge(DOB) =25

--How to drop a function
--drop function fn_calculateAge


Regards,
Sql Query for jobs
#https://www.youtube.com/@SqlQueryforjobs

#sql #mysql #thisisqld #sqlserver #sqlab #nosql #postgresql #whitsundaysqld #jsuisqlf #northlakesqld #pacosqlos #redlandsqld #esql #gatosqls #sqlinjection #sqlimer #pacosqls #mssql #southerndownsqld #igersqld #sqldeveloper #plsql #batsqld #sqlite #nswvsqld #cmcrocksqld #nationalparksqld #pacosql #bestplacesqld #sqlsaturday #holtyspicsqld #cairnsqld #sqlmiami #mysqli #phpmysql #unicefmasqla #sqlife #smallbusinessqld #personalisedplatesqld #oldsql
#sql #python #java #javascript #programming #html #database #sqlserver #css #php #coding #developer #programmer #software #datascience #mysql #o #webdeveloper #machinelearning #code #audiomobil #sqldeveloper #spl #computerscience #sq #oracle #webdevelopment #data #dataanalytics #linux
#technology #computer #development #bigdata #backend #programador #coder #codinglife #caraudio #microsoft #csharp #sqldatabase #softwaredeveloper #informationtechnology #tecnologia #mongodb #powerbi #developers #c #it #worldcode #ti #web #programminglife #softwaredevelopment #artificialintelligence #ai #cienciadacomputacao #angular #programmerslife
stored procedures,stored procedures sql,stored procedure,sql stored procedures,what is a stored procedure,stored proc sql,how to use a stored procedure,stored proc,sql server,sql stored proc,alex the analyst,data analyst career,data analyst,data analytics,database
stored procedure in sql server,
create a stored procedure in sql server management studio,
stored procedure in sql server javatpoint,
stored procedure in sql server optimization,
stored procedure in sql server practice,
stored procedure in sql server syntax,
Difference between Stored procedures and Functions