Video:
Why You Need to Refresh Your Views After Adding Columns to a Table, Part 1
-
Skill level:
300 (Intermediate)
-
Run Time:
06:45
-
Instructor:
Scott Whigham
Description:
Have you ever found yourself working in a table where you made a change to that table and now your view of the data does not reflect the changes? After you add a column to a table, the view you created will not pickup the changes. In this first video in the section Scott will set-up the situation and demonstrate the discrepancy between the table and the view. In later videos he will demonstrate who goes on behind the scenes and show you some suggested fixes.
Highlights from this video:
- Setting up the table and view
- Modifying the table
- Table vs View: Updated data
and much more
Download
and watch this video
NOTE: You will need the TSCC codec
installed to view video
Scott Whigham
Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive
video training libraries focusing on technical training. Scott is also an experienced
consultant, trainer, and author with more than a decade of hands-on experience working
with SQL Server databases, writing and debugging applications using Visual Studio,
and performance tuning. Scott designed the architecture (websites, class libraries,
and database) for the LearnItFirst.com websites and, most
re...
(Scott's full bio can be found here)
|
Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys
|
200
|
Download
|
|
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs
|
300
|
Download
|
|
Creating Database Diagrams in SQL Server Management Studio
|
200
|
Download
|
|
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause
|
300
|
Download
|
|
JOINs - An Overview of the Five Types of JOINs (Cross, Outer, and Inner)
|
200
|
Download
|
NOTE: This video is part of our
SQL Server Programming (SQL Server 2005/2000): Transact SQL course.
This video is from Chapter
12:
Views in SQL Server
Jump to a specific chapter: