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
Do you know what are the differences between lost updates and uncommitted dependencies?
What is relationship? What number of sorts of relationship are there?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are the security related catalog views? : sql server security
What is the impact on other user sessions when creating indexes?
can SSRS reports Cache results?
Explain the difference between functions and stored procedures in sql server?
How to convert character strings into numeric values?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Which data type columns are the best candidates for full-text indexing?
What are the main differences between #temp tables and @table variables and which one is preferred?
How many ways to create table-valued functions?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is sql server agent and what are the two modes of authentication in sql server?
What are the new features are introduced in sql server 2012 reporting services?