good article, as a beginner for ADO.net, I have one question.

how many new rows will insert by your script? one, number of rows, or the loop...

thank you both for help.

do not understand

SELECT @intValue AS [@intValue], @strValue AS [@strValue], @bitValue AS [@bitValue]

maybe you can explain a little bit.

Part 2 is as good as part one,  thanks.

one question:

what severity level error can be handled by @@error? below 17? and what is the example for severity level 16? I...

I am looking for this solution actually, our sqlmail hang everytime after exchange server reboot... your article helps. thanks.

By the way, when you mentioned that "locking strategy comes at a cost", did you mean Oracle rollback segment? I'd like to see your comments on the tradeoff of Oracle's...

When I mention Oracle's advantage, I actually want to say that select statement in TSQL put a lock on row/page/table, and potentially cause more deadlock than Oracle, because pl/sql select do not put...

This is a wonderful article I wish to see for a long time. I'd like to see the coming series covering the following issues:

error handling on severity level 17,18 and 19....

I don't think sql server will kill inactive process automatically...

deadlock is not only a lock.  it happened only if you have at least 2 transactions, and one transaction hold a lockA and require lockB, but another transaction hold lockB and...

re-write your query and include an "order by " clause will guareentee the order of resultset.

after the index got rebuild, the order that records are returning can be changed because the b-tree...

the optimizing table and index will take longer when there are many fragmentation in tables and indexes, dbcc showcontig will tell you how much fragmentation you have. this operation will...

I'd like to say this is a defect of  sql server, it really should not display anything if the column is null.

Steve,

Thanks for you guys effort on SSC, I'm a regular reader, I think the "Pay review" will work, you guys can publish positive opinion for vendors if they are good,...

this article give some example scinario of why we need sp_addalias, it's helpful.