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
- 9406 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 nosql db?
what is commit? : Sql dba
how to create a test table in your mysql server? : Sql dba
What are literals in sql server?
Enlist the data types that can be used in pl/sql?
how to select first 5 records from a table? : Sql dba
What is parameter substitution in sql?
What is the difference between rollback and rollback to statements?
what tools available for managing mysql server? : Sql dba
Can we create clustered index without primary key?
explain the difference between myisam static and myisam dynamic. : Sql dba
Why is pl sql needed?
What are the different sql commands?
How do I run a sql query in pgadmin 4?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
