Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 View Trouble

Author  Topic 

SamC
White Water Yakist

3467 Posts

Posted - 2002-07-27 : 00:31:10
Views may be letting me down.

Define View MyView (Column1 as MyColumn)
as
Select Column1 from MyTable

Pulls a syntax error.

No way to view Column1 as MyColumn using a view?

Is there a workaround?

SamC

macka
Posting Yak Master

162 Posts

Posted - 2002-07-27 : 04:12:53
CREATE VIEW MyView
AS
SELECT Column1 AS MyColumn
FROM MyTable

macka.

Go to Top of Page
   

- Advertisement -