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..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 drop or delete a single column or multiple columns from an existing table in MySQL. Sometimes, you need to remove a single or multiple unused or obsolete column from an existing table.
Read More..In this article, you will learn how to drop or delete a single column or multiple columns from an existing table in SQL server. Sometimes, you need to remove a single or multiple unused or obsolete column from an existing table.
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..