Trigger

## Sql Trigger Examples on Library Database

In this post We will write some trigger examples on library database. There will be about 30...

Stored Procedure

## Sql Stored Procedure Examples

In this post we will create more than 10 procedure examples. With this examples you can learn how...

General

## Print Pattern Examples Using Sql

There are 11 star pattern examples in this tutorial. I will add more example… In Sql we use...

## Mysql Fibonacci Series With Stored Procedure

What is the Fibonacci series: The first number of this series is 0 and the second number is 1. The...

Mysql

## Mysql Create A Table With Code

In this post I will show you how to create a table with code on mysql database. Sometimes we need...

Select

## Sql Random Number Between 1000 and 9999

There is no direct function in sql that chooses a random number between two numbers. But there is a...

## Sql Random Number Between 1 and 1000

To get random number in sql we use rand() function. But rand() funcition returns decimally random...

Mysql

## How to Calculate Age From Date Of Birth In Mysql

We calculate our age by the difference in full years between our current date and our date of birth...

## Mysql Add Two Number With Function

In this post we will write a function that sums two number and returns result. Then, we will use...

## Mysql Add Two Number With Stored Procedure and Output Parameter

In this post we will learn how to create a stored procedure with output parameter and how can we...

Mysql

## Mysql Random Number Between 1 and 100

Rand() function is used to select random numbers in Mysql. This function doesn’t get...

Stored Procedure

Function

## Sql Random Number Between 0 and 1

To get random number in sql we use rand() function. Rand() funcition returns decimally random...

Stored Procedure

## Insert Data to A Table With Stored Procedure in Sql

TO DOWNLOAD THE SAMPLE LİBRARY DATABASE CLICK In this post we will do some example about inserting...

Mysql

## Add Two Numbers Examples On Mysql

TO DOWNLOAD THE SAMPLE LİBRARY DATABASE CLICK If we want to sum same column’s value, we must...

Stored Procedure

## Creating A Procedure, That Calculates Age Returning Day, Month...

This procedure gets a parameter and returns three parameters. Those parameters are year, month and...

Stored Procedure

## 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...

Function

## Age Calculate With Function in Sql

With this post we will calculate age with a function. This function gets a parameter with date type...