which statement will take more processing time in SQL Server?
(A) Insert
(b) Update

On Apr 1, 3:33 am, Santhalakshm... (AT) gmail (DOT) com wrote:
The usual way to answer performance questions is to test it.
so please go do your homework.

On Apr 1, 3:33 am, Santhalakshm... (AT) gmail (DOT) com wrote:
The usual way to answer performance questions is to test it.
so please go do your homework.

On Apr 1, 3:33 am, Santhalakshm... (AT) gmail (DOT) com wrote:
The usual way to answer performance questions is to test it.
so please go do your homework.

Santhalakshmi.k (AT) gmail (DOT) com wrote:

Ed's answer is good, but try drop table. It will make the
subsequent insert and update statements for that table run much
faster.

Yes, I think you should do your own homework, too.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

Santhalakshmi.k (AT) gmail (DOT) com wrote:

Ed's answer is good, but try drop table. It will make the
subsequent insert and update statements for that table run much
faster.

Yes, I think you should do your own homework, too.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

Santhalakshmi.k (AT) gmail (DOT) com wrote:

Ed's answer is good, but try drop table. It will make the
subsequent insert and update statements for that table run much
faster.

Yes, I think you should do your own homework, too.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.