SQL Server Performance

View

Discussion in 'General Developer Questions' started by amankazi, Sep 18, 2006.

  1. amankazi New Member

    1) How many rows any view can hold in SQL server 2000?
    2) How can i create a view which holds data of a remote machine?
  2. satya Moderator

    1) Books online states
    quote:
    A view can be thought of as either a virtual table or a stored query. The data accessible through a view is not stored in the database as a distinct object. A view is used to do any or all of these functions:

    Restrict a user to specific rows in a table.
    For example, allow an employee to see only the rows recording his or her work in a labor-tracking table.

    Restrict a user to specific columns.
    For example, allow employees who do not work in payroll to see the name, office, work phone, and department columns in an employee table, but do not allow them to see any columns with salary information or personal information.

    Join columns from multiple tables so that they look like a single table.


    Aggregate information instead of supplying details.
    For example, present the sum of a column, or the maximum or minimum value from a column.


    2) Refer to the books online again for 'Views' & Linked servers sections for more information.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. Madhivanan Moderator

    Refer Books On Line for all your general questions. Also make use of Google

    Madhivanan

    Failing to plan is Planning to fail

Share This Page