stupied question -what is a definite difference between view and query 2

[Rousseau10]

why would you use a view vs a query???
I need something concrete to know when to use which !!!



TANKS!

I was the first American Soldier to put a basketball hoop up in Iraq, only to have it stolen by a soldier from different camp. Newbee - Adam

 

[jitter]

Look up the following in BOL

views-SQL Server, overview

This should give you some information to get started.

Basically views can help with security. You can use a view to only show certain data while keeping sensitive data away from the user running the view. This allows you to not give any permission to the user to view the underlying table but give them permission to run the view.

Anyway, hope this helps.

jitter

Instead of shooting where I was, you should have shot where I was going to be. - Lrrr (Planet Nintendio64)

 

[mrdenny]

Basically a view is a select statement that is storred within the database.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[Rousseau10]

TANKS

I was the first American Soldier to put a basketball hoop up in Iraq, only to have it stolen by a soldier from different camp. Newbee - Adam

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)