Use SQL Server Management studio to create a view

When I use SQL Server Management studio of SQL Server 2005 to create a view, it seems that there are the following problems: I use it to create a view of the database under SQL Server 2000:

In the view, use select * From sometable to create a view, add a field to sometable, and then select this view. This field is not displayed, unless you re-run the view creation script. View with sp_helptextCodeIt is estimated that * is expanded internally into all fields.

If * is used when creating the view of the SQL Server 2005 database, it seems that after the creation is successful, it will expand * into all fields, you can see the expanded field when you open the view source code again. I remember it.

Although it may be more efficient to expand * into all fields, if it is not for the benefit of * (all fields in a table can be obtained anytime, anywhere, regardless of how the table is changed ), I won't use * either *.

I don't know how to solve this problem ......

Use the query analyzer to create a view.