Category: MS SQL

How To Create, Use and Delete SQL View?

Posted on 08/11/201823/12/2018 by İsmail Baydan

SQL Programming language and SQL Database engines provide some useful mechanisms in order to make management of the data easier. SQL View is one of them which can be used

How To Download And Install SQL Server Management Studio On Windows?

Posted on 08/11/201808/11/2018 by İsmail Baydan

SQL Server is a service running on Windows operating systems. In order to manage this SQL server service and instances with GUI we need to install Microsoft SQL Server Management

How To Download and Install MS SQL Server 2017 Express On Windows?

Posted on 07/11/201810/11/2018 by İsmail Baydan

Microsoft SQL Server is provided with different licenses. Free version is named Express Edition . Express Edition is very useful if we need a little database. Download We will download

Most Useful SQL Commands List with Examples

Posted on 17/09/201817/09/2018 by İsmail Baydan

SQL or Structured Query Language is a standard language used to to create, list, update, delete databases, tables, records. It provides this functionality with different type of commands. In this

SQL “Select Into” Statement Usage Tutorial

Posted on 01/09/201801/09/2018 by İsmail Baydan

SQL provides different statements in order to select into existing table, variable, temp table in various database servers like Oracle, MySQL, PostgreSQL etc. In this tutorial we will examine how

How To Prevent SQL Injection in Php Applications?

Posted on 03/11/201620/11/2018 by İsmail Baydan

I have an application and I have complex requests tot the server. There are a lot of database operations. Managing them can become very hard some times. In this situation

What is The Difference Between Inner and Outer Join?

Posted on 16/10/201617/11/2018 by İsmail Baydan

Sql is the language where a lot of data can be get with different logic. In an enterprise environment we may need to use complex SQL queries to get meaningful