Sunday , 25 June 2017

Query Designer in SQL Server

Query Designer in SQL Server In this article you will learn how to create queries using Query Designer in SQL Server. You don’t need to have any SQL knowledge for using Query Designer in SQL Server, with Query Designer you can create queries easily. To open query designer first you need to open Query Editor. You can open query editor …

Read More »

Variables in Delphi

Variables in Delphi In Delphi programming language you specify the variables with keyword “var“. You put “var” after procedure but before begin. In this tutorial I am going to show you how to declare variables and assign values to them in Delphi. In the end the results will be shown in Message Box. First of all add a button into your …

Read More »

Restore your database in sql server

Restore your database in sql server In this article you will understand how to restore your database from your database backup file. If you don’t know how to create database backup please read my article about Database Backup first. In SQL server you can restore your database in several ways. First I am going to show you how to use SQL Server …

Read More »

Backup database in SQL Server

Backup database in SQL Server To backup your database is one of the most important duties that database administrators does. You always need to have the latest backup in case anything goes wrong such as hardware failures, human errors, network intrusions. Sometimes databases upgrade can go bad or operating system can crush. The risk is always high. So when this happens you …

Read More »

Data types in Delphi

Data types in Delphi There are several data types in Delphi. In this article you will learn all of the data types that Delphi contains. There are 6 main categories in Delphi for data types and these are the following; Integer, String, Floating Point, File, Boolean and Other. Integer Data Types Type Description Byte 8-bit unsigned integer ShortInt 8-bit signed …

Read More »

Insert Update Delete in SQL Server

Insert Update Delete in SQL Server In this article I will show you an example of how to use insert, update and delete commands in SQL Server. Insert Insert command in basically used to insert or add new record into your database table. See the query syntax below. [crayon-594efe50408ed722020142/] You can say we had a field ID in the table …

Read More »

Scalar Functions in SQL Server

Scalar Functions in SQL Server Scalar functions in SQL Server return a single value, based on the input value  Below there is a list of Scalar functions and in this article I am going to show you how Scalar Functions are working with an example. UPPER() – Converts a field to upper case LOWER() – Converts a field to lower …

Read More »

Functions in SQL Server

Functions in SQL Server Function is a database object in SQL Server. It is a set of sql statements that accepts only input parameters. Functions can return single value or table. You can not get multiple results from one function. There are 2 types of functions in sql server.  System Defined Functions and User Defined Functions. In system defined functions is …

Read More »

Transactions in sql server

Transactions in sql server A transaction is the propagation of one or more changes to the database. For example, if you are creating a record or updating a record or deleting a record from the table, then you are performing transaction on the table. It is important to control transactions to ensure data integrity and to handle database errors. Transactions …

Read More »