John Gibb johngibb

## UPDLOCK HOLDLOCK.sql
SET STATISTICS TIME OFF
SET STATISTICS IO OFF
SET NOCOUNT ON
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.MyTable') AND type in (N'U'))
	DROP TABLE dbo.MyTable
GO
	SET STATISTICS TIME OFF
	SET STATISTICS IO OFF
	SET NOCOUNT ON
	GO

	IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.MyTable') AND type in (N'U'))
	DROP TABLE dbo.MyTable
	GO