Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / dk
Insert into tablename (c1,c1,c3,...) values(v1,v2,v3,...)
and we can also use
Insert into tablename values(v1,v2,v3,...)
but in this we must have to know numbers of columns and we
have to insert values for all not null columns
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to create a new login name in ms sql server?
What is the difference between a "where" clause and a "having" clause?
How to create sub reports?
What is an entity-relationship diagram (erd)?
How to enable tcp/ip protocol on a sql server?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Does the order of columns in update statements matter?
how you can deploy an ssrs report?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
How to generate create function script on an existing function?
What are the advantages of mirroring?
Does index slows down insert statements?
Explain the different types of joins?
Define outer join?
