-------------------------------------------------
--Check to see if temp table exists
-------------------------------------------------
IF OBJECT_ID('tempdb..#myTempTable') IS NOT NULL
BEGIN
PRINT '#myTempTable Already Exists... Dropping'
DROP TABLE #myTempTable
END
ELSE
BEGIN
PRINT '#myTempTable does not yet exist...'
END
-------------------------------------------------
--Create temp table to hold values
-------------------------------------------------
CREATE TABLE #myTempTable
(
ID int
, customer varchar(50)
)
PRINT '#myTempTable Created'
--Check to see if temp table exists
-------------------------------------------------
IF OBJECT_ID('tempdb..#myTempTable') IS NOT NULL
BEGIN
PRINT '#myTempTable Already Exists... Dropping'
DROP TABLE #myTempTable
END
ELSE
BEGIN
PRINT '#myTempTable does not yet exist...'
END
-------------------------------------------------
--Create temp table to hold values
-------------------------------------------------
CREATE TABLE #myTempTable
(
ID int
, customer varchar(50)
)
PRINT '#myTempTable Created'
No comments:
Post a Comment