Technological stuff. Programming Languages
We all understand that functions in C# have a function signature, function body and a return type. The signature comprises the parameters sent to the function, the function body is the lines of code executed…
Solid principals are some best practices that can be followed in software development and also called Design Principal. S: Single Responsibility Principal (SRP), SRP means that every object will have a single responsibility and area…
Introduction to Dynamic SQL Dynamic SQL is a programming technique that allows you to construct SQL statements dynamically at runtime. It allows you to create more general purpose and flexible SQL statement because the full…
SQL Server THROW statement overview The THROW statement raises an exception and transfers execution to a CATCH block of a TRY CATCH construct. The following illustrates the syntax of the THROW statement: 123 THROW [ error_number , message , state ]; In this syntax: error_number The error_number is an…
If you develop a new application, you should use the THROW statement instead. SQL Server RAISEERROR statement overview The RAISERROR statement allows you to generate your own error messages and return these messages back to the application using the same format…
SQL Server TRY CATCH overview The TRY CATCH construct allows you to gracefully handle exceptions in SQL Server. To use the TRY CATCH construct, you first place a group of Transact-SQL statements that could cause an exception in a BEGIN TRY…END TRY block…
SQL works based on set e.g., SELECT statement returns a set of rows which is called a result set. However, sometimes, you may want to process a data set on a row by row basis. This is…
The CONTINUE statement stops the current iteration of the loop and starts the new one. The following illustrates the syntax of the CONTINUE statement: 1234567 WHILE Boolean_expressionBEGIN — code to be executed IF condition CONTINUE; — code will be skipped if the condition…