This article describes how to check if a temporary table exists before you delete it. IF OBJECT_ID(‘tempdb..#tmpTable’) IS NOT NULL…
DBCC CHECKIDENT can reseed (reset) the identity value of the table. For example, YourTable has 25 rows with 25 as…
I had a problem with a SQL Server 2008 database that had a log file in excess of 90gb, when…
When creating a SELECT query, sometimes you may want to display a dynamic field with a different value depending on…
VBScript does not implicity allow the Sleep command that you can use in the VB Programming language, to force the…