In this article, you’ll learn how to check if a column exists or not in a table in SQL Server. There are different ways to check if a column exists or not in a table in SQL Server. I hope you all know how to add a new column to an existing table in SQL Server.
Read More..In this article, you’ll learn how to solve an SQL Server error: invalid object name 'string_split'. The error message "Invalid object name 'string_split'" typically occurs when you are trying to use the STRING_SPLIT function in SQL Server, but the function is not recognized.
Read More..In this article, you’ll learn how to change the compatibility level of a database in SQL Server. In SQL Server, to change the compatibility level of a database in SQL Server, you can use the ALTER DATABASE statement.
Read More..In this article, you’ll learn how to check a database’s compatibility level in SQL Server. There are different ways to check the compatibility level of a database in SQL Server.
Read More..In this article, we will learn about how to split comma-separated string values in SQL Server.
Read More..In this article, we will learn about how to get random records from the database table in SQL Server. In SQL Server, To retrieve random records from a database table, you can use the NEWID() function to generate a random value and then order the result set by this value.
Read More..In this article, you’ll learn how to fix the SQL Server error: save changes are not permitted. This problem occurs when you try to save a table in SQL Server Management Studio (SSMS). The good news is that It is a very easy and simple setting problem that can be fixed in 5 seconds by following these steps:
Read More..In this article, you’ll learn how to get or return the server name using a query in SQL Server. There are 2 ways we are using in this post to return the server name using a query in SQL Server.
Read More..In this article, you will learn how to get or extract the week number of a year from a date in SQL Server. You can use the DATEPART() function to get the week number of a year from a date.
Read More..In this article, you will learn how to get or extract the months from a date in SQL Server(T-SQL). Here in this article, we are doing this in 3 ways to extract the month from a date. We are using the MONTH(), DATEPART(), FORMAT() functions to get or extract the month from a date in SQL Server.
Read More..