sql 建立臨時 Table

CREATE TABLE dbo.#News
(
News_id int NOT NULL,
NewsTitle nvarchar(50),
NewsContent nvarchar(50),
NewsDateTime datetime
)
INSERT INTO dbo.#News (News_id, NewsTitle, NewsContent)
VALUES (1,'BlueGreen', 'Austen')

SELECT * FROM dbo.#News
DROP TABLE dbo.[#News]   --釋放資源