While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
No Answer is Posted For this Question
Be the First to Post Answer
What is nolock?
What is the beast way to write CTE in SQL Server ?
Explain features and concepts of analysis services?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What are the dis_advantages of stored procedures, triggers, indexes?
What is update_statistics command?
What is a natural primary key?
Can you please explain the difference between function and stored procedure?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Can we update data in a view?
Why I have to use stored procedures?
Explain different isolation levels?
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)