mardi 5 mai 2015

How come stored procedure will not create table with IF statement

USE [WORKFILES]
GO
/****** Object:  StoredProcedure [dbo].[MLINT]    Script Date: 05/04/2015 16:49:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[MLINT]

AS

IF OBJECT_ID('WORKFILES.dbo.MLINT05', 'U') IS NULL

BEGIN
        --CREATE CMPDTE TABLE
CREATE TABLE WORKFILES.dbo.MLINT05
(DTSTAMP DATETIME NOT NULL)
END

BEGIN
        --INSERT TIMESTAMP
INSERT INTO WORKFILES.dbo.MLINT05
SELECT (getdate())
END

BEGIN
SELECT CONVERT(varchar(20), DTSTAMP)
FROM [WORKFILES].[dbo].[MLINT05]
END

Aucun commentaire:

Enregistrer un commentaire