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 |
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L
What is application role in sql server database security? : sql server security
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
What is a dbms wizard?
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
Mention the command used to rename the database.
How is sql server used?
What is Trace flag?
Display a roll having miminum marks in two subjects?
What is the difference between UNION and UNIONALL?
5 Answers CarrizalSoft Technologies, CTS,
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)