UPDATE statement can on a single table or on the multiple
table?
Answers were Sorted based on User's Feedback
Answer / govind
yes. But by using views(some) we r able to update the
multiple table
| Is This Answer Correct ? | 17 Yes | 4 No |
Answer / sandeep
single table.
View is updatable if it is a only one table reference view.
| Is This Answer Correct ? | 3 Yes | 1 No |
Explain about integration services of Microsoft SQL server?
How to use subqueries with the in operators in ms sql server?
What is SQL Profiler what is the use of it?
2 Answers 247Customer, Steria,
Can we hide the definition of a stored procedure from a use?
What are the steps you can take to avoid “deadlocks”?
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
What is an execution plan? When would you use it?
What is difference between process and thread? Explain lazy writer funcationality.
Explain encryption of entire databases without the need for application changes in sql server 2008?
Do you know how to send email from database?
What is difference between delete & truncate commands?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)