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,780 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,780 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
904 reads
By Chris Yates
In the rush to adopt artificial intelligence, many organizations have quickly built ethical frameworks,...
By Rohit Garg
What Is TempDB and Why It Matters TempDB is a shared system database in SQL...
By Daniel Janik
Boost Your Azure Fabric Pipelines: Don’t Overlook This Crucial Spark Setting Are your Azure...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Hi all, I have a data flow task with: Flat File Source (csv) ->...
Hi all, I have a data flow task with: Flat File Source (csv) ->...
You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires? What single or multiple tools would you use to answer the questions around resource needs?
See possible answers