Answer Posted / vini778

It is used for raising the error from sql statement
Eg shown below

IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
Raise an error with the details of the
exception
DECLARE @ErrorMessage NVARCHAR
(
MAX
)
DECLARE @ErrorSeverity INT;
DECLARE
@ErrorState INT;
SELECT
@ErrorMessage=ERROR_MESSAGE
(
)
,
@ErrorSeverity=ERROR_SEVERITY
(
)
,
@ErrorState=ERROR_STATE
(
)
;
-- Use RAISERROR inside the CATCH
block to return error
-- information about the original
error that caused
-- execution to jump to the CATCH
block.
RAISERROR
(
@ErrorMessage,-- Message
text.
@ErrorSeverity,--
Severity.
@ErrorState -- State.
)
;

What are the purposes of using .net?

1141

---

Explain the difference between constants and read-only variables?

1162

---

Explain can 2 different applications use the same dll in gac at the same time?

1155

---

Explain me why do we use msmq?

1094

---

What is managed code execution?

1194

---

What is the difference between response.redirect & server.transfer?

1221

---

Explain the features that are common to all .Net languages.

1211

---

What should you do to store an object in a viewstate?

1140

---

What is RPC? What is the use of it?

1260

---

What is the difference between encrypting a password and applying a hashing?

1203

---

Will my .net app run on 64-bit windows?

1147

---

What method do you use to explicitly kill a users session? How?

1073

---

What is the difference between .net 2000 and .net 2005(features)? Which one is better?

1030

---

Explain about .Net products?

1183

---

Differentiate between managed and unmanaged code?

1217

---