How To Create View in SQL Server 2005

Create View

Right Click on Views and Click on New View...
After you click on New View... you will see a new dialog box that need you add your table.
To Add your table you can double click on your table name or select your table name and than click Add button.
After you add table your already. You can Click Close button to finish add table.
Tick on columns name that you want to select it from your table.

Or you can write your SQL Statement to select it by condition too. Ex:
```
SELECT     Price, ProductName, ProductID
FROM         dbo.tblProduct
WHERE     (ProductID = 1)
```
Click on Button Execute to show your result.

Or you can click on Query Designer and then click on Execute SQL.
after your excute you will see your result
Click on Save Button to Save your view
Enter your view name and then click Ok button. when you want select data from table product you can select it from your view.