How to create view in sql server 2005-2008:

creating view in sql server 2005-2008:

Open Management Studio and drill down to the target database

• Expand the database and locate View

• Right-click on View and select New View

• In Tables page, select target table and click Add

• Edit the view definition in the appearing GUI

• Click the Save button

• Name the view and save it