what is meant by sql injection with example and one more
question how to catch the errors in sqlserver

Answer Posted / kanan

how to catch the errors in sqlserver?

BEGIN TRY
SELECT 1/0
END TRY

BEGIN CATCH
RETURN ERROR_NUMBER()
RETURN ERROR_MESSAGE()
RETURN ERROR_LINE()
END CATCH

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the categories of stored procedure?

512


What is collation sensitivity? Explain different types.

537


What is the difference between DATETIME2 and DATETIME?

617


Why de-normalization required?

564


What authentication modes does sql server support?

588






How do I make a resultset scrollable?

492


Please explain what is “asynchronous” communication in sql server service broker?

501


Name and describe few console utilities for ssrs?

249


How many levels of sp nesting are possible?

545


List few advantages of stored procedure.

528


What is data set in report?

95


What are the components of sql server service broker?

501


What are the different types of backups that exist?

674


How extra digits are handled with numeric data type literals?

516


How to create indexed view?

572