i don't want the message as 14 rows updated just it should
update what it will do
- 4 Answers
- 7914 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 purpose of the sql select top clause?
What programs use sql?
what is the use of set statement in tsql? : Transact sql
Explain mutating table error.
How many types of functions are there in sql?
How do I find duplicates in a single column in sql?
What are sql queries used for?
What are commit, rollback, and savepoint?
Is coalesce faster than isnull?
What is pl sql architecture?
Is sql considered coding?
what is a table in a database ? : Sql dba
What is the difference between function and procedure in pl/sql?
What is a sql schema used for?
What does plv msg allows you to do?
