Need help on how to update SQL query using VC++

[John502]

Hi, I have one SQL query, i want to update it in one database. Please check that SQL query below. update employee set emp_name = 'Ravi' where emp_id = 1 Now i want to get the count of how many rows get updated.. Can any one help me out as it urgent requirement for me.. Thanks John.

[dan sh]

ExecuteNonQuery would do that if you are speaking of managed C++.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

[Niladri_Biswas]

Try with OUTPUT command introduced with SQL SERVER 2005. This link may help you http://www.aspfree.com/c/a/MS-SQL-Server/Wonders-of-the-OUTPUT-Clause-in-SQL-Server-2005/[^] http://www.databasejournal.com/features/mssql/article.php/3598636/OUTPUT-clause-in-SQL-Server-2005.htm[^] :)

Niladri Biswas

[Mycroft Holmes]

I always use stored procs but this may work.

update employee set emp_name = 'Ravi' where emp_id = 1; Select @@Rowcount Updated

Not sure if it requires a colon or a semi colon.

[John502]

Hello Holmes, Yes, you have given exact query.. i have executed this query in QueryAnalyser it is working fine and this what i am expecting.. Can you please explain me how to execute this query through VC++..? Thanks John.

[Mycroft Holmes]

Sorry, I wouldn't know VC++ if it wandered up and bit me, I suggest you take it to the language forum.

Never underestimate the power of human stupidity RAH