SQLTea – Our new SQL Tutorial App on Google Play Store We are happy to announce our new SQL tutorial
SQLTea – New SQL tutorial app in Google play store
Continue reading
Month: August 2014
How to restore database backup in SQL SERVER
In this article, I am going to explain the process of Database restoration using the SQL Server Management Studio. In
Share this:
How to take Database backup in SQL SERVER
Introduction This article explain the simple way to take the database backup in SQL SERVER which can be easily understandable
Share this:
Database Creation using SQL Sever Management Studio (SSMS)
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command.
Share this:
Database Creation using Create Database command
In SQL Server, database can be created by 2 ways:- Using Create Database command Using SQL Sever Management Studio (SSMS).
Share this:
IN clause in SQL Server
With IN clause, we can specify multiple values in a WHERE clause. For example, in case of “IN”, one can
Share this:
AVG() function in SQL Server
Avg():- This function is used to get the average value of a numeric column Syntax:- SELECT AVG(column_name) FROM table_name
Share this:
UPPER() function in SQL Server
UPPER():- This function is used to convert the value of a column to upper case. Syntax: SELECT UPPER(string) OR
Share this:
LEN() function in SQL Server
LEN():- This function is used to get the length of the given string value. Syntax:- Select len (stringvalue)
Share this:
LOWER() function in SQL Server
LOWER():- This function is used to convert the value of a column to lower case Syntax:- Select LOWER (string)
