Tutorials
Courses

Similar Topics

Web Technologies35.5K+ articles

Python21.2K+ articles

DSA20.3K+ articles

Experiences16.0K+ articles

Misc8.3K+ articles

Databases2.1K+ articles

How To1.7K+ articles

SQL1.4K+ articles

SQL Server160+ articles

Miscellaneous4+ articles

SQLServer

9 posts

How to Create Daily, Weekly, and Monthly Report in SQL Server?

Last Updated: 16 December 2021

SQL Server is a versatile database and a most used database throughout the world. In this article, let us see SQL queries how to get Daily, Weekly, and Monthly reports fro...read more

article_image

How to Export Data to the .CSV File Using SQL Server Stored Procedure?

Last Updated: 30 September 2024

Exporting data from SQL Server to a CSV file is a common task when handling large datasets or sharing data with other applications. SQL Server Management Studio (SSMS) pro...read more

Scalar Function in SQL Server

Last Updated: 24 February 2023

Pre-requisites: Categories of SQL FunctionsIn SQL Server, a scalar function is a type of user-defined function that returns a single scalar value based on the input parame...read more

article_image

Inline Table Valued Function in SQL Server

Last Updated: 03 March 2023

In SQL Server, an Inline Table-valued function (ITVF) is a user-defined function that returns a table as its result. Unlike a scalar function that returns a single scalar ...read more

article_image

Encryption and Schema Binding Option in User Defined Function

Last Updated: 24 February 2023

Encryption and schema binding are two separate options that can be applied to user-defined functions in SQL Server.Encryption:When you create a user-defined function in SQ...read more

article_image

How to Find the Missing Number in SQL Column?

Last Updated: 02 April 2023

Given a column in the table having values from 1 to N, one value will be missed. The task is to find the missing number.So, let's start by creating a database first.Step 1...read more

article_image

Upsert Operation in SQL Server

Last Updated: 29 January 2025

In SQL Server, managing data efficiently is crucial, especially when working with real-time or large datasets. The upsert operation is a combination of the INSERT and UPDA...read more

article_image

How to Modify a Stored Procedure in SQL Server?

Last Updated: 17 May 2024

In this article, we will learn to modify the created stored procedure in MS SQL.You can modify the Stored Procedure in two ways. one is by using a client called SSMS and o...read more

article_image

SQL Server Interview Questions

Last Updated: 16 May 2025

Data is growing every day, and it plays a big part in making important decisions. To manage this data, we need reliable databases, and SQL Server is one of the most popula...read more

article_image

Interview-Questions

Interview Questions