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
What are views used for?
What is temporal data type?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are window functions in sql server?
What is the purpose of object explorer and its features? : sql server management studio
Is it possible in sql table to have more than one foreign key?
How can I add Reporting Services reports to my application?
How to configure odbc dsn with different port numbers?
What will be query used to get the list of triggers in a database?
How many types of cursor type are there?
How can change procedure in sql server?
Explain for xml explicit mode?
what purpose does the model database serve? : Sql server database administration
How can sql injection be stopped? : sql server security
When would you use the stored procedures or functions?