MS SQL Server

How to find locked tables and kill the session in Microsoft SQLServer?

February 25, 2023 1 minute read

Open SQL Server Management Studio (SSMS). Connect to the SQL Server instance. Open a new query window. Execute the following query to find the sessi...

How to get the number of rows affected in SQL Server (Transact-SQL)?

November 6, 2021 less than 1 minute read

You can retrieve the no of affected rows using the system variable - ‘@@ROWCOUNT’