Tag: TSQL
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 […]
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.
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 […]
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 […]
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. […]
