Answer / sabareetha

If the view is created with single table. Updating a view
will affect the origival records in the table

Answer / ravi sharma

in the case if same table (all column) are make a view then
updations reflect the original record in the table.

but mostly make a view to security purpose the , uniques
are constaint column are not use,
then not be reflect .

Answer / sangita

No

Answer / anil

yes

Answer / soorai ganesh

No. Updating View will not affect the table records.

How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  

What is primary key index?

0 Answers  

How to execute a sql statement using odbc_exec()?

0 Answers  

What is hot add cpu in sql server 2008?

0 Answers  

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

Why use “pivot” in sql server?

0 Answers  

how to avoid cursors? : Sql server database administration

0 Answers  

What is user defined stored procedures?

0 Answers  

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

How do indexes help, types?

0 Answers  

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

How to count duplicated values in a column in ms sql server?

0 Answers