Shivam Dogra 
In this SQL Server tutorial, we will learn about SQL Server stored procedure if exists update else insert. And we will also try to implement some examples related to it. SQL Server stored procedure if exists update else insert A SQL Server table is a shared database object used to store data organizationally. We may … Read more >>
In this SQL Server tutorial, we will learn about the SQL Server function return table. We will illustrate this topic using multiple examples. SQL Server function return table In this section, we will learn how to create a user-defined function in SQL Server that returns table-type data. For this task, first, we need to know about user-defined … Read more >>
Here we will learn and understand how to use the SQL Server EOMONTH function to find the last day of the month from the table by the query. And which will be explained with the help of a demonstrated example. SQL Server Last Day Of Month The SQL Server EOMONTH function is used to return … Read more >>
In this SQL Server tutorial, we will learn about “SQL Server First Day Of Month” where we will discuss how to get the first day of the month from the table. We will understand and learn some examples so that you can understand the concept much better. Here is the complete list of topics that we … Read more >>
SQL Server has no creator column. Quick answer: to find who created a stored procedure in SQL Server, read the default trace with sys.fn_trace_gettable and check LoginName on event 46 (Object:Created). The catch is how long the trace keeps it. I measured that, then logged changes two ways you can copy. Test Setup and the … Read more >>
Recently, I got the requirement to get the month name from a specified date in SQL server. This article will discuss multiple approaches to achieve this functionality. How To Get Month Name From Date In SQL Server Let us discuss all the approaches individually. Approach-1 Using DATENAME() We can use the DATENAME() in an SQL … Read more >>
In this SQL Server tutorial, we will discuss how to alter view in SQL Server. We will discuss various ways and examples to modify a view. The following are some examples that we are going to discuss. If you have not yet installed SQL Server, first install SQL Server 2019. How To Alter View In SQL Server … Read more >>
Recently, I got the requirement to get the table row count for some of the tables in my SQL Server database. In this article, I will walk you through all the possible approaches to get table row count in SQL Server. How To Get Table Row Count In SQL Server Let us discuss all the … Read more >>
We can get column descriptions or extended properties in SQL Server using different approaches. In this article, I will walk you through multiple approaches to do this. How To Get Column Description In SQL Server Let us discuss all those approaches individually. Approach-1: Using SQL Server Management Studio (SSMS) To get column description in SQL … Read more >>
As an SQL server developer, it is pretty essential for you to know what SQL server edition you are using?. In this article Let us discuss all the approaches to check SQL Server edition. How To Check SQL Server Edition We will discuss all the possible approaches to check the edition of your SQL server. … Read more >>