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.
| Author |
Topic |
|
dwjongbloed
Starting Member
9 Posts |
 Posted - 2008-06-17 : 16:06:53
|
| can anyone tell me why when I create a view if I do this in my select statement "CAST(CrewNo AS char(10)) AS CrewNo" and then save the view the above CAST statement will be changed to this "CAST(CrewNo AS char(10)) AS Expr1". After I have it saved and then go back and change it back to "CAST(CrewNo AS char(10)) AS CrewNo" it will stay that way. Just looking for a reason why this is happening as I don't know if I'm doing something wrong or not. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-17 : 16:09:51
|
| It probably depends where you are creating your view. Have you tried with a CREATE VIEW statement in a query window rather than through the designer?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
dwjongbloed
Starting Member
9 Posts |
Posted - 2008-06-17 : 16:12:11
|
| I haven't tried it w/ a create view statement yet just been using the designer. I'll try a Create view statement to see how that works. |
|
|
|
|
|
|
creating views in SQL 2005