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…
SQL Server BREAK statement overview In the previous tutorial, you have learned how to use the WHILE statement to create a loop. To exit the current iteration of a loop, you use the BREAK statement. The following illustrates the typical syntax…
Overview of WHILE statement The WHILE statement is a control-flow statement that allows you to execute a statement block repeatedly as long as a specified is TRUE. The following illustrates the syntax of the WHILE statement: 12 WHILE Boolean_expression { sql_statement…
The IF…ELSE statement is a control-flow statement that allows you to execute or skip a statement block based on a specified condition. IF statement The following illustrates the syntax of the IF statement: 1234 IF boolean_expression BEGIN { statement_block }END In this syntax, if…
Overview of the BEGIN…END Statement The BEGIN…END statement is used to define a statement block. A statement block consists of a set of SQL statements that execute together. A statement block is also known as a batch. In other…