Answer Posted / laxman

SELECT @RC = @@ROWCOUNT
SELECT @ER = @@ERROR
if we use above statements then @@error will be reset with
0.
i think right one is

select @er=@@error,@rc=@@rowcount

what is database replication? : Sql server database administration

986

---

How to search for a string in all stored procedure in sql server?

950

---

We need to perform what steps in the following order to work with a cursor?

1168

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2880

---

How to connect php with different port numbers?

1002

---

What is a bit datatype?

924

---

Can a rule be bound to any column of any data type?

911

---

What are distinctive joins find as a part of sql?

908

---

How do I start sql server 2016?

857

---

What is the difference between online clustering and Offline clustering?

2356

---

Which data type columns are the best candidates for full-text indexing?

917

---

What are the system database in sql server 2008?

975

---

What is a join in sql? What are the types of joins?

1008

---

Differentiate between delete and truncate.

995

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

900

---