UPDATE statement can on a single table or on the multiple
table?
Answer Posted / sandeep
single table.
View is updatable if it is a only one table reference view.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is rank function?
What are system databases in ms sql server?
What is dknf in normalization form?
Define cursor locking
What is right outer join in sql server joins?
Explain how to use linked server?
What are the requirements to use odbc connections in php scripts?
how to define testing of network layers? : Sql server database administration
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
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?
What is a trigger in sql server?
How to call stored procedure using http soap?
To which devices can a backup be created and where should these devices be located? : sql server management studio
Can we perform backup restore operation on tempdb? : sql server database administration
How do we know if any query is retrieving a large amount of data or very little data?