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 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..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..In this article, you will learn how to check or find the column name which is the primary key column of a specific table in SQL Server. There are various ways to find the primary key column in SQL server.
Read More..In this article, you will learn how to get or find out the identity column without using the actual column name or without knowing the actual column name.
Read More..In this article, you will learn how to format dates with a format function in SQL server. In the SQL Server, 2008 and earlier versions of SQL Server used the CONVERT function to format the DateTime.
Read More..In this article, you will learn how to find the shortest string and the longest string from a column of a table in an SQL server. There are various ways to find the shortest and longest string from a column of the table in SQL Server.
Read More..