Microsoft SQL Server Tutorials
As a database developer, I was working on the query and wanted to get the exact time of a system on which the SQL server is currently running; then, I could use the CURRENT_TIMESTAMP Function provided by the SQL Server. The CURRENT_TIMESTAMP() function returns the computer’s current time stamp in ‘YYYY-MM-DD hh:mm: ss.mmm’ format. This … Read more >>
While creating a function in the SQL query, I was required to convert integers into fixed-length strings in SQL Server. After multiple research studies, I found a simple and standard way of converting. In this SQL Server tutorial, you will learn how to convert int to fixed length string in SQL Server. You will understand … Read more >>
Do you know how to convert Datetime to string in SQL Server? If not, follow this tutorial to learn how. We can use the CONVERT and CAST functions to convert a value(of any datatype) into a specified datatype. Continue reading the tutorial to know more. Convert Datetime using the CAST function To convert Datatime to … Read more >>
Have you ever needed a specific portion of a string in SQL Server? Is that possible? Yes, we can retrieve a few characters from the column of a string by substring. This helpful feature allows you to change strings, easily adding flexibility to database queries. This tutorial will explain substring in SQL Server, including syntax, … Read more >>
Do you want to use the convert function on the SQL Server? Follow this tutorial to see how to use the convert function to change from integer into varchar in SQL Server. Converting integers into variable characters in SQL Server is a simple operation. SQL Server provides different methods to transform functions. In this tutorial, … Read more >>
Sometimes, when we are working on the test environment, our SQL Server agent will not work, and it will show the error as Access Denied. In this tutorial, I will show you the steps to solve this issue in SQL Server Management Studio. Let’s get started to see the troubleshooting methods. SQL Server Agent is … Read more >>
The purpose of the SQL Server port is to transmit and receive data. In this tutorial, we will see which ports are available by default in SQL Server and what the differences between them are. Continue reading to learn more. What is a Port in SQL Server A Port is defined as an endpoint of … Read more >>
SQL Query is an important language for database management. It will allow multiple users to share the procedure. Whenever we want to use the particular code again and again, we can go for the stored procedure in SQL Server. In this SQL Server tutorial, you will learn how to create advanced stored procedures. Let’s get … Read more >>
In this tutorial, I will explain how to use the SQL Server convert function. Data conversion is an important aspect of databases. It is an effective way to manage and organize data into different data types, allowing the user to access, view, or modify data when required. Let’s get started to get more about this. … Read more >>
Do you want to know SQL Server 2019 features? You are on the right page to check the features of Microsoft SQL Server 2019. SQL Server 2019 New Features Below are Microsoft SQL Server’s top 8 features. Let’s discuss each feature in-depth to learn more. Big Data Clusters A recent addition to the SQL Server … Read more >>
Download A 40 pages PDF And Learn Now.