#Temporary tables, indexes and procedures work!

10

Please login or register to vote for this query.

(click on this box to dismiss)

#Temporary views and functions return errors stating they're not allowed. Use Text-only results, and include the execution plan to see the index has been used.

Super User

Q&A for computer enthusiasts and power users

-- #Temporary tables, indexes and procedures work!
-- #Temporary views and functions do not.
-- Use Results to Text.

-- CREATE PROCEDURE #T_P AS
-- Begin
--   PRINT GETDATE()
-- RETURN
-- End
-- g-o
--CREATE PROCEDURE #T_P2 @v VARCHAR(MAX) AS
--  PRINT @v
--RETURN;
-- GO
CREATE TABLE #Test (id int IDENTITY(1,1) NOT NULL, v VARCHAR(MAX) NOT NULL)
-- go
CREATE INDEX #IX_T on #Test(id)
-- g-o
--CREATE VIEW #V_T AS SELECT v FROM #Test
--CREATE FUNCTION #G_D() RETURNS DATETIME AS
--BEGIN
--  RETURN GETDATE()
--END
INSERT INTO #Test(v) SELECT @@VERSION
-- go
INSERT INTO #Test(v) VALUES ('Yay!')
-- go
-- #T_P
-- go
-- #T_P2 'Test'
-- go
SELECT * FROM #Test

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results