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
If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.
What is indexing explain it with an example?
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required
How to use values from other tables in update statements in ms sql server?
Why de-normalization required?
How to assign null values to variables or columns?
What is a View ? Can we insert, Update and delete a view?
How to divide query output into multiple groups with the group by clause in ms sql server?
Explain “not null constraint” in sql server?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is database isolation in sql server? : sql server database administration
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?
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)