Month: September 2026
-
Cursor Usage in MSSQL: Advanced Control in Database Operations
MSSQL offers a range of powerful features to perform complex database operations. One of these features is cursors. Cursors enable navigation and control over data within a database table. Cursors are ideal for scenarios where data needs to be processed row by row and sequential operations are required. In this article, we will discuss the…
-
The Usage of SELECT INTO in MSSQL
SQL (Structured Query Language) is a powerful tool used for managing and manipulating relational databases. One of the key statements in SQL is the SELECT statement, which allows us to retrieve data from one or more tables. In Microsoft SQL Server (MSSQL), the SELECT INTO statement is a variation of the SELECT statement that enables…
-
Performing Subtotal Calculations with ROLLUP in SQL
In SQL, the ROLLUP operator allows us to generate subtotal calculations in our query results. Subtotals can provide valuable insights by summarizing data at different levels of granularity. This article explores how to use the ROLLUP operator to perform subtotal calculations in SQL, specifically focusing on generating a “Total” label for the “product” column. The…
-
Understanding Pivot in MSSQL
Pivot is a powerful feature in Microsoft SQL Server (MSSQL) that allows you to transform rows into columns, providing a convenient way to summarize and analyze data. In this article, we will explore the usage of the pivot operator in MSSQL and understand how it can be applied to reshape data. What is Pivot? In…
-
How to List All Triggers in a MSSQL Database
In MSSQL, triggers are special types of stored procedures that are automatically executed in response to specific events, such as data manipulation operations on tables. Triggers can be useful for enforcing business rules, auditing changes, or performing additional actions when certain conditions are met. If you want to list all triggers in a specific database,…
-
Understanding the Differences Between IDENTITY, SCOPE_IDENTITY(), and IDENT_CURRENT() in MSSQL
In SQL Server databases, there are three important functions used to retrieve values associated with auto-increment fields: IDENTITY, SCOPE_IDENTITY(), and IDENT_CURRENT(). Although they serve a similar purpose, these functions have distinct characteristics and use cases. This article aims to explore the differences between them and provide a clear understanding of their individual functionalities. The IDENTITY…
-
How to List Table Sizes in MSSQL
Using SQL Server Management Studio (SSMS): You can use SQL Server Management Studio (SSMS) to list the size of tables. Follow the steps below: Using this method, you can manually check the size of each table. Using T-SQL Query: Make sure to replace “YourDatabaseName” with the actual name of your database. When you execute the…