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
- 9216 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 is the size of partition table?
What is a heap in sql?
Compare sql & pl/sql
How many types of normalization are there?
Does sql support programming?
How do I copy a table in sql?
What is pl sql script?
Explain scalar functions in sql?
Does sql*plus also have a pl/sql engine?
How do I access sql anywhere database?
What is union and union all keyword in sql?
Why should I use postgresql?
Why is sql better than hql?
How many types of index are there?
What are the two virtual tables available at the time of database trigger execution?
