April 4, 2008 at 5:26 am
Hi experts
Is it possible to create a view specifying temporary table or can we create a view for a temporary table.
TIA
April 4, 2008 at 5:34 am
Ratheesh.K.Nair (4/4/2008)
Hi expertsIs it possible to create a view specifying temporary table or can we create a view for a temporary table.
TIA
No, it is not possible.
Regards,
Andras
April 4, 2008 at 5:35 am
No, we cannot.
April 4, 2008 at 5:36 am
Some more information (or proof :))
http://msdn2.microsoft.com/en-us/library/ms187956.aspx
From this page:
The SELECT clauses in a view definition cannot include the following:
....
A reference to a temporary table or a table variable.
Regards,
Andras
April 4, 2008 at 6:02 am
Thanks to all ...:)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply