insert into tablename (col1,col2,........) values (val1,val2,........)

syntex of insert

Question Posted / mahathi

Answer Posted / mahathi

insert into tablename (col1,col2,........) values
(val1,val2,........)

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1327

Explain acid?

1084

what is bit datatype? : Sql server database administration

919

What are the different types of collation sensitivity?

1126

What is a hint?

994

What are different types of raid configurations? : SQL Server Architecture

1086

Why does sql studio use a single registered database repository? : sql server management studio

1000

What the different components in replication and what is their use?

953

what is denormalization? : Sql server database administration

927

how can u get last observation in an unknown dataset ?

2436

What are the encryption mechanisms in sql server?

1030

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1034

What do you mean by an execution plan? Why is it used? How would you view it?

932

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1032

What is raid? : SQL Server Architecture

1180