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).
In this article,...
2014-08-20 (first published: 2014-08-17)
7,778 reads
In SQL Server, database can be created by 2 ways:-
Using Create Database command Using SQL Sever Management Studio (SSMS).
In this article,...
2014-08-20 (first published: 2014-08-17)
7,778 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,027 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,245 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
876 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
579 reads
LEN():- This function is used to get the length of the given string value.
Syntax:-
Select len (stringvalue)
For example,
...
2014-08-14
736 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
951 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
416 reads
Max():- This function gives the maximum value of the selected column
Syntax:-
Select Max (col1) from table_name
In this article, we are...
2014-08-13
833 reads
RTRIM():-This function is used to get the string after the removal of all trailing blanks.
Syntax:-
RTRIM ( character_expression )
For example:-
Select RTRIM('Vivek Johari ...
2014-08-13
903 reads
By Rayis Imayev
(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media...
By Steve Jones
It’s been a week since I flew home from London and Redgate to begin...
When you're searching about the future of a career in MS SQL Server, you're...
Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...
Hi everyone I have two db - one is test and other is archive. ...
Comments posted to this topic are about the item The Long Weekend
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers