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.
)
;

Explain the purpose of Remoting in .NET?

1098

---

Explain the difference between the while and for loop.

963

---

What is the base class of Button control in .NET?

1058

---

What's the .net collection class that allows an element to be accessed using a unique key?

1003

---

Tell us what is heap and what is stack?

1089

---

What is .net technology?

1007

---

What is the advantage of .net?

950

---

Types of evidence in .net with context to CAS

2123

---

How can you turn-on and turn-off cas?

941

---

Explain what is the difference between response.redirect & server.transfer?

1058

---

Which Namespace is used to to achieve MultiThreading in .NET?

1049

---

How boxing and unboxing occures in memory?

1124

---

What is .net assembly?

1019

---

What is the difference between boxing and unboxing?

926

---

Describe session handling in a webform, how does it work and what are the limitations?

1012

---