• Sounds like you are asking for answers to a homework question.

    Use GOOGLE to search for your answers. If you do, the following are typical of the answers you will find.

    1). A view is a virtual table that consists of columns from one or more tables. Though it is similar to a table, it is not stored in the database.

    2). Functions are computed values and cannot perform permanent environmental changes to SQL Server (i.e. no INSERT or UPDATE statements allowed).

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]