In this SQL Server tutorial, we will learn How to create a stored procedure in SQL Server for search functionality. We will also discuss different examples of search functionality. The complete list of topics discussed in this article is listed below. So, before creating a stored procedure to implement some search, first, we should understand … Read more >>

In this article, we will discuss an error “Msg 266: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements.” that I faced when I was working with the SQL Server transactions and stored procedures. I will describe how I encountered the issue. Also, I will explain the cause and solution of … Read more >>

For a stored procedure for insert and update in SQL Server, you write two: an INSERT returning the new ID through an OUTPUT parameter, and an UPDATE by key that checks @@ROWCOUNT. For bulk rows, a table-valued parameter beat a loop 38 to 1. Quick answer: SET @NewID = SCOPE_IDENTITY(); after the INSERT, and IF … Read more >>

In this SQL Server tutorial, we will discuss how to drop a stored procedure in SQL Server. I will explain what are the various methods to drop stored procedures with the help of some examples. Prerequisite for this tutorial: What is a stored procedure in sql server How to drop stored procedure SQL Server? If you want … Read more >>

In this SQL Server tutorial, we will discuss how to pass parameters to view in SQL Server. Further, we will also illustrate the following topics in this tutorial. Can we pass parameters to a view in SQL Server? No, in SQL Server, we cannot pass parameters to a view. And it can be considered as one main limitation … Read more >>

This  SQL Server tutorial will discuss the If Else in Trigger SQL Server statement. We will discuss and draw lessons from several cases to help you comprehend the subject better. The whole list of subjects we’ll discuss is provided below. If Condition in Trigger SQL Server Here we will learn and understand how to use SQL Server IF … Read more >>

This SQL Server tutorial will illustrate how to create a SQL Server Trigger for Update operation. Additionally, we will take a look at multiple examples where we need to create SQL Server Trigger for Update. In SQL Server, we can create triggers that can be executed based on various SQL Server events. And one such … Read more >>

In this SQL Server tutorial, we will understand how to disable a trigger in SQL Server either by using a T-SQL query or by using SQL Server Management Studio. As Database Administrators, we might need to create multiple triggers on the same SQL Server Table. However, the role of these multiple triggers might be different … Read more >>

This SQL Server tutorial will explain the use of SQL Server Join with Max Date function. The MAX() function in SQL Server is utilized to fetch a maximum value from the set of values. Now there will be a requirement where we need to fetch maximum values from multiple tables. In such cases, we need … Read more >>

In this article, I will explain how I encountered the error “SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’.” Also, I will explain what I did to resolve this error. Problem: Recently, when I was working with SQL Server stored procedures, I wanted to create a stored procedure that creates a directory in … Read more >>