“SQL Server 2005 Inside Programming” reading notes – View

Get your FREE Diabetes Recipes eBook!

1. Do not view the use of select * (see reason 2 examples)
2. To change the table structure needed sp_refreshview refresh the view after, otherwise the view will not reflect the new structure; how the view V1 in the script is select * from T1, when we add a column in the T1, if you do not execute exec sp_refreshview ‘dbo.V1 ‘, the new column will not appear in the query when V1
3. Unless TOP or FOR XML, can not View, CTE using Order By, and the View and the CTE in order by credible
4. How to open only part of a table column changes to permissions? Modify permissions to remove the table, adds a column to open the view, and modify permissions to add the view.