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
List the different index configurations possible for a table?
What is normalization and what are the advantages of it?
What are the parts of a function?
Is INSTEAD OF trigger directly applicable to Table ?
whats new about truncate in sql server 2008?
What is cdc in sql server?
What are types of storage modes? : sql server analysis services, ssas
What is stored in the mssqlsystemresource database? : sql server database administration
What is report snapshot in ssrs?
What is amo? : sql server analysis services, ssas
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
Define right outer join?
What are unicode character string data types in ms sql server?
Define indexes?