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 change tracking in sql server?
How to create percentile function?
What is join query?
What happens if strings are casted into wrong code pages in ms sql server?
What is fill factor and pad index?
What is the stuff?
Explain different types of collation sensitivity?
What are the different type of replication in sql server?
How to select some specific columns from a table in a query in ms sql server?
What is statement level trigger?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
on line cluster can we make if yes tell me the procedure
Mention the differences between local and global temporary tables.
List the different types of collation sensitivities in sql server?
query processing