RSS

Re: How does views work in MS SQL

Please support our MS SQL advertiser: Programming Forums

How does views work in MS SQL

•

Join Date: Jun 2005

Location: Texas

Posts: 120

Reputation: jwshepherd is an unknown quantity at this point

Rep Power: 4

Solved Threads: 5

jwshepherd jwshepherd is offline

Offline

Junior Poster

Re: How does views work in MS SQL

Jun 16th, 2005

Views are basically a few tables group together by a server side query.

•

select * from X where Car=’Ford’ and Color=’Yellow’

would return only Ford = Yellow

Help with Code Tags

(Toggle Plain Text)

select * from X where Car=’Ford’ or  Color=’Yellow’

would return

Help with Code Tags

(Toggle Plain Text)

Alfa Yellow
Volvo Yellow
Ford Yellow
Ford Blue

You can create a view by creating a sql query on the server, since it runs on the server, it is usually fasterthan the client requesting x number of tables and y pieces from each one.

I believe the information you recieved may be a little inaccurate

DaniWeb Home > Forums > Web Development > Databases > MS SQL > How does views work in...

Re: How does views work in MS SQL

How does views work in MS SQL

Re: How does views work in MS SQL