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

A developer company sends dlls to the client. Some client is not happy current functionality, so request some modification. Developer made some changes and send new dll to all clients. Some client is happy with old version, tell me minimal change to so that neither clients get affected?

921

---

What is operator overloading in .net?

1033

---

Name the classes that are introduced in the system.numerics namespace.

1041

---

Tell us what is the native image generator?

1128

---

Explain .net framework overview?

1056

---

What is the advantage of .net core?

975

---

Please explain what is reflection and what is it for?

927

---

How do I spawn a thread?

946

---

What are the purposes of using .net?

1080

---

what is prototype design pattern in .net

1005

---

Which namespace does it belong to by default?

1010

---

What’s different between process and application in .net?

1056

---

Explain about the Common Language Runtime?

1103

---

Explain what is an interface and what is an abstract class? Please, expand by examples of using both. Explain why?

1030

---

What is your observations between vb.net and vc#.net?

1101

---