BEGIN TRANSACTION;
CREATE TABLE #t(f VARCHAR(100) NOT NULL);
INSERT INTO #t(f) VALUES ($x);
COMMIT TRANSACTION;

SELECT 'text' AS component, f AS contents FROM #t;