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
976 reads
In this article, I am going to explain the process of Database restoration using the SQL Server Management Studio. In...
2014-08-17
976 reads
This article explain the simple way to take up the backup of a database which can be easily understandable by...
2014-08-17
884 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
871 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,016 reads
LEN():- This function is used to get the length of the given string value.
Syntax:-
Select len (stringvalue)
For example,
...
2014-08-14
732 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
574 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
409 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
941 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,235 reads
And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one conditions...
2014-08-13
549 reads
In today’s data-driven world, having the right tools to manage and process large datasets...
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
In a previous post we went through how to use Docker Build Cloud to...
Comments posted to this topic are about the item Realities of Predictive Analysis
Just came across something weird. Was wondering if anyone else has ever seen this....
My database was in suspect mode, and when I checked using DBCC CHECKDB, it...
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers