We only have four products in our table, so that’s why we’re selecting only the top three records.Įverything looks good, so we can execute the whole CREATE VIEW SQL statement to create the view with the SELECT As you can see, we have our Long-Sleeve Logo Jersey product in different sizes and sold quantities. Syntax again since T-SQL is exactly the same as in CREATE VIEW SQL statement except the fact that instead of theĪs I mentioned earlier, let’s use the code from below to create a bit more complex view:īut before we run the script, we can again just highlight the SELECT statement and see what it returns as shownīasically, what we are doing here is for each product in the Product table, we are fetching all the quantities and add them together per product. Ironically, before modifying a view, we will create another view with a bit more complex T-SQL using aggregates in it rather than having a simple SELECT statement that is pulling everything from a table.
A view is based on the result set from a query, and this command allows us to change the structure and definition of a query. The primary goal will be to get familiar with the ALTER VIEW command used to modify views and change the output. In the first write-up so in order to follow along, head over and read the Creating views in SQL Server We will continue using examples on a sample database and data created In this one, we are moving on and focusing on how to modify views. In my previous article, we looked at how to use the CREATE VIEW SQL statement to create views.
0 kommentar(er)
