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
How the authentication mode can be changed?
What is subquery explain with example?
how to select a field with firstletter as capital and remaining are small letters
What is database normalization?
7 Answers Deloitte, Digicel, JPMorgan Chase, Verifone,
Explain what are the database objects? : SQL Server Architecture
Explain what are various ways to enhance the ssrs report?
How to disconnect from a sql server using mssql_close()?
What are the different types of queries?
Tell me the phases a transaction has to undergo?
Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?
Explain different types of locks in sql server.
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)