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...
2014-08-17
978 reads
In this article, I am going to explain the process of Database restoration using the SQL Server Management Studio. In...
2014-08-17
978 reads
This article explain the simple way to take up the backup of a database which can be easily understandable by...
2014-08-17
893 reads
Avg():- This function is used to get the average value of a numeric column
Syntax:-
SELECT AVG(column_name) FROM table_name
In this article,...
2014-08-14
875 reads
With IN clause, we can specify multiple values in a WHERE clause.
For example, in case of "IN", one can use...
2014-08-14
1,023 reads
LEN():- This function is used to get the length of the given string value.
Syntax:-
Select len (stringvalue)
For example,
...
2014-08-14
735 reads
LOWER():- This function is used to convert the value of a column to lower case
Syntax:-
Select LOWER (string)
or
SELECT LOWER(column_name) FROM table_name
For...
2014-08-14
577 reads
LTRIM ():- This function is used to get the string after the removal of leading blank spaces.
Syntax:-
LTRIM ( character_expression )
For example:-
Select LTRIM ...
2014-08-14
414 reads
Substring():- This function is used to return the specified number (third argument "len") of characters from a given string(first argument)...
2014-08-14
948 reads
UPPER():- This function is used to convert the value of a column to upper case.
Syntax:
SELECT UPPER(string)
OR
Select UPPER(Column name)...
2014-08-14
1,238 reads
And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one conditions...
2014-08-13
551 reads
By Steve Jones
One of the cool things I’ve seen with the new Flyway CLI is that...
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
Comments posted to this topic are about the item The Weather Outside Is Frightful
I am using the following code to read a json file. I can display...
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers