Functions and Stored Procedures have few similarities such as: They are group of T-SQL statements which is stored on the server.These group of T-SQL statements are executed as a unit. Abstracts the developer from the implementation details since he needs to just call the procedure or function. Accepts parameters and return values. Are used to create […]
Error Handling in SQL Server
Exception is a runtime error which prevents the normal execution of code.There are different ways of error handling in SQL Server. Each error in SQL Server has certain information attached to it.Some of the important information attached to each error is: Message Number Each error has a error number. Severity Number […]