Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / neetu
a view is a virtual table.it's an object that derives it's
data from one or more tables.it ensures that users are able
to retrieve and modify only the data which is seem by them.
u r unable to update attributes becoz views allow only one
of the underlying tables to be updated at a time.u need to
update attributes by giving two separate update commands.
| Is This Answer Correct ? | 24 Yes | 8 No |
Post New Answer View All Answers
Explain the Ways to improve the performance of a sql azure database?
What the different components in replication and what is their use?
How to identify current user in ssrs report?
What is cursors? And what are the different types of cursor?
What are the tables in sql?
your distribution database is full what will u do
If a table does not have a unique index, can a cursor be opened on it?
How to concatenate two character strings together?
Difference between Sql server reporting services and Crystal reports?
What are user-defined functions (udfs) in sql server?
What happens if null values are involved in comparison operations?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How to convert numeric expression data types by assignment operations?
What are the differences between having and where clause.
How to remove duplicate rows from table except one?
