What can i do with views - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

What can i do with views

Author

Topic

lew26
Starting Member

5 Posts

Posted - 2007-11-06 : 17:48:18

Hello,

I am kind of new to using views. What types of queries can i use with view (i.e. select, insert, update, delete) in mssql 2000?

DigitalSolvers
Yahoo: DigitalSolvers
MSN Live: lew26@msn.com
Skype: DigitalSolvers

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-11-06 : 17:51:32

You can only define a VIEW with a SELECT query.
But you can use a VIEW to UPDATE, INSERT and DELETE records.

E 12°55'05.25"
N 56°04'39.16"

lew26
Starting Member

5 Posts

Posted - 2007-11-06 : 22:25:11

oh k thank

DigitalSolvers
Yahoo: DigitalSolvers
MSN Live: lew26@msn.com
Skype: DigitalSolvers

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-11-07 : 01:00:51

SQL Server help file will have more informations

Madhivanan

Failing to plan is Planning to fail

arorarahul.0688
Posting Yak Master

125 Posts

Posted - 2007-11-07 : 03:14:07

http://www.sql-server-performance.com/articles/dba/view_basics_p1.aspx

try this link

Rahul Arora
MCA 07 Batch
NCCE Israna, Panipat
HRY, INDIA

######################
IMPOSSIBLE = I+M+POSSIBLE

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources