i don't want the message as 14 rows updated just it should
update what it will do
- 4 Answers
- 7869 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 trigger in sql and its types?
what is the difference between a having clause and a where clause? : Sql dba
What is a system versioned table?
What is the life of an sql statement?
what is uncommittable transactions? : Transact sql
Can we create view in stored procedure?
What is plpgsql language?
what are the advantages of sql ? : Sql dba
What are the most important ddl statements in sql?
What are actual parameters and formal parameters?
Explain the rollback statement?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Explain how exception handling is done in advance pl/sql?
explain about mysql and its features. : Sql dba
Explain isolation levels. : Transact sql
