i don't want the message as 14 rows updated just it should
update what it will do
- 4 Answers
- 8459 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 stuff function and how does it differ from the replace function? : Sql dba
How many databases can sql express handle?
What is the difference between partitioning and sharding?
Which query operators in sql is used for pattern matching?
What is difference between ms sql and mysql?
How to display Row Number with Records in Oracle SQL Plus?
What is Materialized View? In What Scenario we Use Materialized View?
What mean sql?
How do I run a script in sql developer?
how to include comments in sql statements? : Sql dba
Is sql a backend?
Is primary key clustered or nonclustered?
What are the types of sql commands?
What is scope of pl sql developer in future?
what is a trigger? : Sql dba
