| Author: vipul 05 Sep 2008 | Member Level: Diamond | Rating:  Points: 6 |
Hi,
Non of the operation is doing by the View only you can select the multiple table throw one view like
select * from tableView.
vipul,
http://dongavipul.blogspot.com
|
| Author: Geetha 05 Sep 2008 | Member Level: Gold | Rating: Points: 2 |
HI
Refer this link,
it will give you a idea about insert,update & delete in views
http://www.fast-track.cc/t_advance-sql_30_union_all_views.htm
Regards,
Geetha.
|
| Author: Kundan Kumar Sinha 05 Sep 2008 | Member Level: Gold | Rating: Points: -20 |
Hi Gopi,
Creating Views
A view can be created by using the CREATE VIEW statement.
Syntax
CREATE VIEW view_name
[(column_name[,column_name]….)]
AS select_statement
Example
CREATE VIEW vwCustomer
AS
SELECT CustomerId, Company Name, Phone
FROM Customers
You can modify data by using a view in only one of its base tables even though a view may be derived from multiple underlying tables.
ie. you can insert, update or delete records using view.
You cannot modify the following of Columns using a view:
Columns that are based on computed values.
Columns that are based on built_in_function like numeric and string functions.
Columns that are based on row aggregate functions.
Regards,
Kundan
|
| Author: Barani 05 Sep 2008 | Member Level: Silver | Rating: Points: 2 |
u can do anything and everything within the view ,
U can insert,delete,select,update in the view whenever the data in view gets changed those changes are reflected in appropriate table i am sure i have tried it
CREATE VIEW vwCustomer
AS
SELECT t1.CustomerId, t2.Company Name, t2.Phone
FROM Customers t1,Contact t2 where t1.CustomerId=t2.CustomerId
Example:
Select * from vwcustomer
update vwcustomer set Company Name='XXX' where CustomerId=1
similarly u can delete records
REGARDS ,
BARANI
|
| Author: http://venkattechnicalblog.blogspot.com/ 05 Sep 2008 | Member Level: Diamond | Rating: Points: 2 |
Please check my blog
http://venkattechnicalblog.blogspot.com/2008/09/views-in-sql-server.html
Regards,
Venkatesan Prabu .J
|
| Author: @@@ Hyderabadi Biryani @@@ 05 Sep 2008 | Member Level: Diamond | Rating: Points: 2 |
Hi,
Check out my article to get answers to your questions.
http://www.dotnetspider.com/resources/808-An-Indepth-coverage-Views.aspx
Thanks -- Vj
|
| Author: Sriram 05 Sep 2008 | Member Level: Gold | Rating: Points: 2 |
View is an Virtual Table
view it wont occupy any memory space
Views is used for Security Purpose
Through to select particular Columns
view has two properties Schemabinding and Encryption
Through View we can do insert,Delete,Update....
example
create view emp_view
as
select empid,empname ,empaddress from employee
select * from emp_view
create view emp_view1
as
select * from empployee inner join empsalary
on
employee.empid=empsalart.empid
SriramRamaswamy
|
| Author: Satyanarayan SushilKumar Bajoria 07 Sep 2008 | Member Level: Diamond | Rating: Points: 3 |
Hi,
what are the restrictions imposed on views?
Restrictions imposed on views are as follows:
1>A view can be created only in the current database.
2>The name of a view must follow the rules for identifiers and must not be the same as that of the table on which it is based.
3>A view can be created only if there is a SELECT permission on its base table.
4>A view cannot derive its data from temporary tables.
5>In a view,ORDER BY cannot be used in the SELECT statement.
Thanks and Regards
S.S.Bajoria
|