Bijay 
When working with SQL Server, I was required to use conditional logic that allowed me to use it in different scenarios. Then, I used the IF Else condition in a stored procedure to get the required output. How to Use If Else in SQL Server Stored Procedure Let’s explore conditional logic in SQL Server stored … Read more >>
While working on the project, I was required to perform some calculations that required me to use arithmetic operators. In SQL Server, arithmetic operations are a fundamental part of data manipulation and querying. Here, I will discuss using of arithmetic operators in SQL Server. How to Perform Arithmetic Operations in SQL Server While performing queries … Read more >>
Recently, I was stuck in a situation where I had a table with a primary key value but no auto-increment. However, if the table holds thousands of records, adding the next ID value for the INSERT operation is quite difficult. How to Get Auto Increment ID in SQL Server To resolve this situation in SQL … Read more >>
As a database developer, I should protect my data in the organization. The importance of data backup cannot be ignored. Recently, I tried to back up the data on the SQL server. There are different types of backup options available in the SQL Server. Initially, I faced some challenges in choosing, but finally, I did … Read more >>
As a developer, I could not recall the exact names of stored procedures while working with them. Thousands of stored procedures were in the databases, and searching for and finding them wasn’t easy. Fortunately, there are several ways to locate stored procedures in SQL Server by using their full name, a portion of their name, … Read more >>
A few weeks ago, I created a stored procedure in SQL. Later, I need to update the item based on the stored procedure. To do this, we can use the ALTER Procedure in the stored procedure.In this SQL Server tutorial, I will show you how to ALTER stored procedure in SQL Server in detail. Also, … Read more >>
Recently, I worked with date and time data types in SQL Server. I tried to convert a character string including date into Datetime using the CAST() function, and I faced an error Conversion failed when converting date and/or time from a character string. I resolved the error and sharing here how I did. This tutorial explains … Read more >>
As a database developer, it is important to keep the proper name for the stored procedure to understand and manage the database. In this SQL Server tutorial, we will discuss some of the naming conventions used for the stored procedures in SQL Server. Also we will see SQL Server stored procedure best practices. SQL Server Stored … Read more >>
A week ago, I got the requirement from our client to select the latest record from the SQL table. I did it through SQL query and took the output. This tutorial will discuss simple and easy ways to select the newest record in SQL Server. Also, I will explain how to get maximum and minimum … Read more >>
Generally, when filling out Online forms, we don’t know what to fill in the particular columns. For example, the Email field will not be mandatory (which is an optional parameter)every time, so in the front end, the user skips it. That column will be taken as Null or not applicable in the system. Here, we … Read more >>
Download A 40 pages PDF And Learn Now.