访问TSQL从CLR存储过程创建了#temp表

CREATE TABLE #temp (
    [column1] [data_type] NULL,
    [column2] [data_type] NULL,
    ...
);

INSERT INTO #temp (
    [column1], [column2], ...
)
SELECT
    [column1], [column2], ...
FROM
    [source_table];

SELECT
    [column1], [column2], ...
FROM
    #temp;

DELETE FROM #temp;

BEGIN TRANSACTION;

-- SQL statements go here

COMMIT TRANSACTION;

IF EXISTS (SELECT * FROM sys.databases WHERE name = 'tempdb')
BEGIN
    DROP TABLE #temp;
END

CREATE TABLE #temp (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    age INT
);

INSERT INTO #temp (id, name, age)
SELECT
    id, name, age
FROM
    my_table;

SELECT
    id, name, age
FROM
    #temp;