SQL SERVER | If Exists nelle versioni 2008 e 2008R2

3 agosto 2015 1 min di lettura Database Microsoft SQL Server Windows

—SQL Server 2008— IF OBJECT\_ID(N'\[dbo\].\[nome\_stored\]’, N’P’) IS NOT NULL DROP PROCEDURE \[dbo\].\[nome\_stored\] GO —SQL Server 2008 R2— IF EXISTS (SELECT \* FROM sys.objects WHERE object\_id = OBJECT\_ID(‘\[dbo\].\[nome\_stored\]’) AND type in (‘P’)) DROP PROCEDURE \[dbo\].\[nome\_stored\] GO

---SQL Server 2008---
IF OBJECT_ID(N'[dbo].[nome_stored]', N'P') IS NOT NULL
DROP PROCEDURE [dbo].[nome_stored]
GO

---SQL Server 2008 R2---
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('[dbo].[nome_stored]') AND type in ('P'))
DROP PROCEDURE [dbo].[nome_stored]
GO