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