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 the different types of backups that exist?
How to start sql server browser service?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What are dml (data manipulation language) statements in ms sql server?
What is the syntax for encrypting a column in SQL Server?
How do you know if sql server is running on your local system?
Explain what are the events recorded in a transaction log?
Explain about thread and memory management process of SQL?
What is a partition key?
What does it mean to invest in the index?
Do you know what are acid properties?
Tell me about pre-defined functions of sql?
How to create a testing table with test data in ms sql server?
What is a field name?
What are the differences between triggers and stored procedures?
