Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to get the query output like n rows affected?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-30 : 11:49:18
Sriram writes "Hi
Advance thanks to all!

In sql server, if I run a command

delete from <table1>

Then I get,

<n> rows affected.. Can I catch this statement as a string i my
java application ...


Why I need this is , if I run the same command again
I get

"The command(s) completed successfully."..

I dont get
"<0> rows affected.."

If I catch this output string I can validate it whether any rows affected in the table or not!

Or is there any possibilty through sql server exception to catch this status as how many rows affected after the execution of the sql command!

Regards
Sriram"
   

- Advertisement -