sql server programming: Can we create views on temporaty table in sql server2000.If yes how can we do that?

From http://www.developmentnow.com/g/113_2004_3_0_2_0/sql-server-programming.htm

Posted via DevelopmentNow.com Groups

Hi

Views or functions are not allowed on temporary tables.






[quoted text, click to view]

[quoted text, click to view]

No but why would you? if you need the table to be accesable to more
than 1 connection use a global (##) temp table

Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx

No. See Create View topic in BOL.

Tom

[quoted text, click to view]

You can't create views on temporary tables prefixed with #(local) or
##(global). However, there is no reason you can't create views on tables
created in tempdb which are NOT prefixed with # or ##. See example below.
Note, these tables will be dropped automatically when the service is
restarted, as with all tempdb objects.

Hope this helps


wBob

-- Pseduo-code
USE tempdb
GO

CREATE TABLE dbo.test_table ... etc
GO

CREATE VIEW dbo.viw_test

AS

SELECT *
FROM dbo.test_table
GO

[quoted text, click to view]