;

Tags: SQL functions Articles


How to Check if a Column Exists in a Table in SQL Server

Tutorialsrack 23/10/2021 SQL Server

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..

How to Get or Return the ISO Week Number from a Date in SQL Server

Tutorialsrack 25/02/2021 SQL SQL Server

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..

3 Ways to Get or Extract the Month From a Date in SQL Server

Tutorialsrack 22/02/2021 SQL SQL Server

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..
Recent Posts
Tags