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

What do you understand by case manipulation functions?

1034

---

What are the limitations of sql express?

1071

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2500

---

What is difference between sql and oracle?

1131

---

Why use subqueries instead of joins?

1081

---

How do I restart sql?

976

---

what does the t-sql command ident_incr does? : Transact sql

1078

---

What is a field in a database?

1065

---

How do you update a table in sql?

990

---

What are different functions in sql?

947

---

Why commit is not used in triggers?

1040

---

Is it possible to create the following trigger: before or after update trigger for each row?

1287

---

Can we enter data in a table in design view?

969

---

How does sql profiler work?

1023

---

how to get a list of columns in an existing table? : Sql dba

966

---