Interested to Buy Any Domain ? << Click Here >> for more details...
i don't want the message as 14 rows updated just it should
update what it will do
- 4 Answers
- 9095 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
What are stored procedures in mysql?
What is a temporal data type?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Why is %isopen always false for an implicit cursor?
What is primary key secondary key alternate key candidate key?
Why stored procedures are faster than query?
What view means?
Why do we use sql constraints?
Which is faster count (*) or count 1?
What do you understand by pl/sql cursors?
What are pl sql procedures?
Explain what is a column in a table?
What is the difference between database trigger and stored procedure?
What is a database? Explain
Can we use threading in pl/sql?
