SQL Server
How to Import Data from Script File into SQL Server
How to Import Data from Script file into MySQL Server? Detailed instructions on how to import data from SQL Server Management Studio (SSMS)
Latest SQL Server Articles
SQL Server
How Does Virtualization Work with SQL Server & What Are The Benefits?
Virtualization has been used for years by organizations looking to liberate their software resources from the bonds of specific hardware devices and instead embrace a more flexible approach that meshes with their need for increased agility.
SQL Server
Basic operations with Database in Microsoft SQL Server
Some basic operations with SQL Server database management system through the SQL Server Management Studio interface tool that you should understand.
SQL Server
Steps to install Microsoft SQL Server on Windows 10
Instructions on how to install Microsoft SQL Server on Windows 10, a database management system from Microsoft. Install SQL Server and SSMS is a GUI tool to support SQL Server manipulation
SQL Server
How to make a connection to SQL Server through SSMS
How to make connection to SQL Server through SSMS (SQL Server Management Studio)? The simplest way to create a connection to SQL Server via SSMS...
SQL Server
Instructions on how to connect to MySQL Server in IntelliJ
How to connect MySQL Server in IntelliJ? Detailed instructions on how to connect to MySQL Server in IntelliJ, it is time to quit MySQL Workbench
SQL Server
What's new in SQL Server Management Studio 18.7?
The SQL Server Management Studio (SSMS) 18.7 release is available for download now. Today, we will be sharing some updates from the release and what's happening in SQL Server Management Studio.
SQL Server
DAY function in SQL Server
The DAY function in SQL Server returns an integer that is the day of the month (from 1 to 31) from the time passed.
SQL Server
GETDATE function in SQL Server
GETDATE function in SQL Server returns the current date of the system.
SQL Server
GETUTCDATE function in SQL Server
This article will show you in detail how to use datetime GETUTCDATE () function in SQL Server with specific syntax and examples to better visualize and capture functions.
SQL Server
MONTH function in SQL Server
This article will show you in detail how to use the datetime MONTH () processing function in SQL Server with specific syntax and examples to better visualize and capture functions.
SQL Server
SQL Server YEAR function
SQL Server's YEAR function returns a 4-digit integer that is the year value in the timestamp passed.
SQL Server
CAST function in SQL Server
The CAST function in SQL Server converts an expression from one data type to another.
SQL Server
CONVERT function in SQL Server
The CONVERT function in SQL Server allows you to convert an expression to any desired data type but can follow a certain format (especially for the date data type).
SQL Server
TRY_CAST function in SQL Server
The article will show you in detail how to use the TRY_CAST data type conversion function in SQL Server with specific syntax and examples to better visualize and capture functions.
SQL Server
TRY_CONVERT function in SQL Server
This article will show you in detail how to use the TRY_CONVERT data type conversion function in SQL Server with specific syntax and examples to better visualize and capture functions.
SQL Server
Check version information in SQL Server
This article will show you in detail how to use the @@ VERSION query to check the information that SQL Server version is using.
SQL Server
CASE statement in SQL Server
This article will show you in detail how to use the CASE statement handling function in SQL Server with specific syntax and examples to better visualize and capture functions.
SQL Server
COALESCE statement in SQL Server
The COALESCE statement returns the expression with the first non-NULL value among the passed expressions.
SQL Server
CURRENT_USER statement in SQL Server
The CURRENT_USER statement returns the name of the current user in the SQL Server database.