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
mardi 5 mai 2015
How come stored procedure will not create table with IF statement
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire