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
What is store procedure? How do they work?
How to reaname table name without using sp_Rename in sql server..?
What do you mean by data integrity?
What is dbcc command in sql server?
What are the different types of sql server replication? : sql server replication
Create and insert into temp table in sql server?
What are the parts of a function?
How to update a field in SQL after ALTERING a row?
How to scale out a federation by Sql statement?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Where is trigger in sql server?
Explain different types of collation sensitivity?
What are the advantages of sql azure?
What is difference between delete & truncate commands?
How to recover from sql injection? : sql server security
