7 Ağustos 2008 Perşembe

TSQL-> IF EXISTS DROP



IF EXISTS (SELECT * FROM [dbo].[sysobjects]
WHERE ID = object_id(N'[schema].[procedure]') AND
OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [schema].[procedure]
GO
CREATE PROCEDURE [schema].[procedure]
AS
BEGIN

Hiç yorum yok: