i don't want the message as 14 rows updated just it should
update what it will do
- 4 Answers
- 7905 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar gupta
Hi,
If you are faceing this issue with sql SERVER THEN ITS
SOLUTION IS
SET NOCOUNT ON : It avoids to diplay message
SEt nocount off : it allows to display message
suppose:
select * from temp1 (Incase 4 rows are there in the table
temp1)
it will prompt you a message as
(4 Row(s) affected)
if you have used
set nocount on
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to find 3rd highest salary of an employee from the employee table in sql?
What program will open a mdb file?
What is the difference between sql and t sql?
How do I remove duplicates in two columns?
Why do we use function in pl sql?
What is transaction control language (tcl)?
What are the three forms of normalization?
What is multiple partition?
what is transaction? : Sql dba
Can there be 2 primary keys in a table?
What is the purpose of a secondary key?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Can a procedure in a package be overloaded?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is sql injection owasp?
