i don't want the message as 14 rows updated just it should
update what it will do
Answers were Sorted based on User's Feedback
Answer / ajexpert
You can acheive this by issuing a command
SET FEEDBACK OFF.
Hope this helps
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / suneel
set feedback off;
this will help for u r question
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / vijay sultampur
SET FEEDBACK Off;
example
SQL> SET FEEDBACK Off;
SQL> select * from dual;
D
-
X
SQL> SET FEEDBACK ON;
SQL> /
D
-
X
1 row selected.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Does mysql_real_escape_string prevent sql injection?
I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.
What is embedded sql what are its advantages?
what is rollback? : Sql dba
Are stored procedures faster than queries?
How to write a query to show the details of a student from students table whose
Is pl sql and postgresql same?
What is difference between stored function and application function?
Write a unique difference between a function and a stored procedure.
Can a table contain multiple primary key’s?
Explain the uses of a database trigger?
where are cookies actually stored on the hard disk? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)