In this post we will learn how to list random record from a table in sql server. We will list the...
LAST ARTICLES
List The Oldest Record In Sql
We will write some example about oldest and youngest records in sql query. To find oldest record we...
Join Same Table Twice In Sql Query
Sometimes, we need to join same table twice in a query. The examples about this issue is at below...
List Same Column Multiple Times By Different Names In Sql
In Sql, we can list same column multiple times by differrent name in sql. We must rename the column...
Sql Group By Day Names
To qroup queries day name we must use datename function in sql. This function gets two parameter...
Create A Function Merge Two String And Returns It
We will create a function that merge two string value and returns it. It is a simple example. There...
Stored Procedure To Divide Numbers And Get Divided Value And...
In this post we will write a stored Procedure. We will divide numbers than we will get divided...
Stored Procedure To Find A Number Is Prime In Sql
We will write a procedure that finds given number is Prime. The procedure gets an integer...
Select All Columns With Group By
In this tutorial we’ll not use group by but we will group records. In other words we’ll...
Function To Find A Number Is Prime In Sql
We will write a funciton that finds given number is Prime. The function gets a number parameter...
Scalar Valued Function Examples
This post contains more than 5 units scalar valued function examples. With this examples you can...
Sql Group By Quarter Examples
We use datepart method to get quarter part of a date. We will do some examples on library database...
Sql Group By Clause Examples
In this post we’ll write many example about group by clause on library database. Some of this...
Sql Stored Procedure Examples
In this post we will create more than 10 procedure examples. With this examples you can learn how...
Create Function Finding the Number Remaining From The Division...
In this example we will create a funciton that finds the number remaining from the division of two...
Finding The Sum Of The Three Numbers With Stored Procedure
In this tutorial web William create a Procedure that Sums Three numbers. The numbers will be...