You can clearly see that I did not do such a good job with this. This SELECT can include a WHERE clause or anything else for that matter that can be put into a SELECT statement. This is a pretty common thing to do, By having a view that already does this we save having to write that function in every query where this is a requirement.
Sometimes coming up with a short descriptive name for your view is easier said than done. You can also see that we have take the birth date column and calculated age.
IF ( OBJECT_ID('dbo.vw_students1') IS NOT NULL ) DROP VIEW dbo.vw_students1 GO CREATE VIEW dbo.vw_students1 AS SELECT lastname , firstname , (firstname ' ' lastname) as "Fullname_fl", (lastname ', ' firstname) as "Fullname_lf", birth_dttm, DATEDIFF(yy, birth_dttm, GETDATE()) - CASE WHEN MONTH(birth_dttm) .
You can think of a view as a lens looking at one or more tables.
Note that for each scenario that we did not need to join any tables.
UPDATE summary_data SET current_category = (SELECT category_id FROM products WHERE products.product_id = summary_data.product_id) WHERE EXISTS (SELECT category_id FROM products WHERE products.product_id = summary_data.product_id); If you want to test your skills using the SQL UPDATE statement, try some of our practice exercises.
You can open Table Designer by opening a new or existing table.
A new version of Table Designer appears for databases in the SQL Server 2012 format.