Run SQL Server Linux container images with Docker
MS SQL Server
How to check if a temporary table exists and delete it if it does before creating a temporary table?
You can check if the previously created temporary table exists before creating the same table again in your stored procedure. Drop them if they exist.
How to search for text in a SQL Server stored procedure, function, or view?
You can use the following T-SQL query to search for text in a SQL Server stored procedure, function, or view.
How to find locked tables and kill the session in Microsoft SQLServer?
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)?
You can retrieve the no of affected rows using the system variable - ‘@@ROWCOUNT’