This procedure gets a parameter and returns three parameters. Those parameters are year, month and...
Author - Thomas Brown
Stored Procedure Example; Calculates Age In Sql
In this post we will create a Stored Procedure that calculates age. In the procedure we will use...
Age Calculate With Function in Sql
With this post we will calculate age with a function. This function gets a parameter with date type...
Sql Group By Month Names
To group queries by month name we must use datename function in sql. This function gets two...
Find The Month Deference Between Two Dates
To Find month difference between two dates, we must use the datediff function. With DateDifference...
Sql Query Birth Date Next Week
TO DOWNLOAD THE SAMPLE LİBRARY DATABASE CLICK Example 3: List students whose birth date is in next...
Sql Birthdate Query
In this post you will learn how to find birth date of customer or student. We will use getdate()...
Scalar Valued Function Examples
This post contains more than 5 units scalar valued function examples. With this examples you can...
Print Pattern Examples Using Sql
There are 11 star pattern examples in this tutorial. I will add more example… In Sql we use...
Create Function Like Replicate Not Using Replicate In Sql
In this tutorial we will create a function.This function runs like replicate function. But we will...