Answer / Shilpi Goswami

The odbc_errormsg() function is not native to MS SQL Server, but it's a PHP extension for ODBC connections. To retrieve error messages in MS SQL Server, you can use the @@ERROR system variable or RAISERROR statement.

Why should you use or avoid select * statements?

0 Answers  

---

What command do we use to rename a db, a table and a column?

1 Answers  

---

What are the different types of cursor?

1 Answers   HCL,

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

What is coalesce and check constraint in sql server?

1 Answers  

---

Can we call future method from trigger?

1 Answers  

---

How to handle errors in Stored Procedures.

2 Answers   Accenture,

---

how to know description of a table in sqlserver 2000

8 Answers  

---

Tell me about the approaches which you used to counter the DI problems.

1 Answers   EXL,

---

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

1 Answers  

---

How make remote connection in database?

1 Answers  

---