Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / gunjan sapra
View is a virtual table,created by users for their own
convienience.
views can be updated as required but the updated data will
not reflect in the base table, since view is the virtual
table not the original table.
so, if we want to update the table we have to update that
outside the view or directly but not using view.
if we update through view its temporary means just in the
view only but will not reflect in the base table.
| Is This Answer Correct ? | 6 Yes | 18 No |
Post New Answer View All Answers
Why I can not enter 0.001 second in date and time literals in ms sql server?
How many types of the database links?
What is the difference between ddl,dml and dcl commands?
Explain about system database?
why would you use sql agent? : Sql server database administration
What is sqlcmd?
How to call a function from a stored procedure in SQL Server ?
Define inner join in sql server joins?
Give me a SQL Query to find out the second largest company?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What are various aggregate functions that are available?
what is sql server? : Sql server database administration
What do you do in data exploration
What is the importance of three tier architecture?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
