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 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 will learn how to get the current timezone of the server in SQL Server. A very common question we developers often encounter is what is the current Timezone of the server where the SQL Server is installed. Here are the two examples to get the current timezone of the server in SQL Server.
Read More..In this article, you’ll learn how to get the list of supported timezones in SQL Server. Microsoft SQL Server provides the sys.time_zone_info server-wide configuration view which returns a list of supported time zones.
Read More..In this article, you will learn how to check if a column exists in a table or not in the SQL server. There are various in-built system catalog views or metadata functions that you can use to check the existence of columns in a table of SQL Server. There are various ways to check whether a column exists in a table or not. Here are some examples to achieve this.
Read More..In this article, you’ll learn how to convert a month name to the month number in SQL Server. In SQL Server, there are no built-in functions to get a month number from a month name. So, here, you can use the MONTH()andDATEPART() functions to convert a month name to its corresponding month number.
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’ll learn how to get or return the ISO week number from a date in SQL Server. In this article, we use the two ways to get the ISO week number from a date. One is the DATEPART() function and the second one is a user-defined function.
Read More..