IF (OBJECT_ID('tempdb.dbo.#table') IS NOT NULL)
DROP TABLE #table
CREATE TABLE #table
(channelid VARCHAR(50),
pmoney DECIMAL(18, 2),
ptype TINYINT,
inday VARCHAR(10),
scale VARCHAR(10),
comScale VARCHAR(10))
--释放临时表
IF (OBJECT_ID('tempdb.dbo.#table') IS NOT NULL)
DROP TABLE #table