Contributing Member
Views, Triggers, Normalization
Can any body explain in detail for
Re: Views, Triggers, Normalization
your question is toomuch theoritical to explain here. It is beyond the scope of this discussion to explain all that here.Please go through some good books ,mauals or u can find vast resources by little web searching
Junior Member
Re: Views, Triggers, Normalization
Views aviews are nothing but saved sql statements, and are sometimes referred as “virtual tables”. Keep in mind that views cannot store data (except for indexed views); rather they only refer to data present in tables. Let’s checkout the basic syntax for creating a view: create view as go there are two important options that can be used when a view is created. They are schemabinding and encryption. We shall have a detailed look on both of these, shortly, but first of all, let’s take a look of an example of a typical view creation statement without any options. Use northwind go create view vwsample as select customerid, companyname, contactname from customers go the above t-sql will create a view named vwsample. Now instead of using the complete select statement to return the above results, you can just use a simple statement like this: select * from vwsample please drop the view if you are following along on your computer, because i will be using the same name throughout the chapter.
Reply With Quote
Reply With Quote