Does insert return anything on MSSQL?

[skurpyun]

Stupid question, but to be honest, this is the first time i've found myself needing to figure this out.
I am using asp to insert & update an MS Sql server table. The problem is as soon as it inserts new data, I need to query it again. Basically, all I want to know is, when using 'connection.execute(insert.....)', is anything returned?
Any help would be greatly appreciated. Thanks.

 

[topher0303]

The insert statement will not return any records. The only ways to return records in the same round trip as the insert is through a stored procedure or sending multiple statements in one execute as follows:

Set rst = cnn.Execute("set nocount on;insert into t1 (col1, col2) values ('6','6');select * from t1 where col1='6';set nocount off;&quot

One of the drawbacks of this is you cannot use a disconnected recordset in this situation.

Is this what you were looking for?

Chris.

 

[skurpyun]

Perfect....that is exactly what I want. tried it and got the desired result. While the drawback is important to be aware of, for my purposes, it's not too significant a problem. Thank you very much. Wow these forums DO work!!

Thanks again, Chris.
-sk