tsql.tar.gz

T-SQL-SPA

T-SQL is a dialect of SQL that is used in Microsoft SQL Server. The popularity of Microsoft's database management system sustains high market demand for people well versed in T-SQL. 

This course teaches the core concepts and syntax of T-SQL. First, you will learn how to create tables, insert data, update existing records, and create relationships between tables. Then, you will be exposed to more advanced constructs of T-SQL, like stored procedures, functions, and triggers. 

By the end of the course, you will be sufficiently adept with T-SQL and be able to perform your day-to-day tasks as software and database developers effectively.

Querying Databases Using Transact-SQL

There are times when we know that our stored procedures or functions might generate an error. In these cases, we can raise custom errors that have readable messages.

## The `RAISERROR()` function

We can intentionally raise an error in our query using the `RAISERROR()` function. It has this syntax:

```SQL
RAISERROR([Message], [Severity], [State])
```

### Example

When this function is called, the execution is transferred to the error processing block. In other words, if the `RAISERROR()` function is called within the `BEGIN TRY` block, the execution switches to the `BEGIN CATCH` block:

There are times when we know that our stored procedures or functions might generate an error. In these cases, we can raise custom errors that have readable messages.

# The `RAISERROR()` function

We can intentionally raise an error in our query using the `RAISERROR()` function. It has this syntax:

```SQL
RAISERROR([Message], [Severity], [State])
```

## Example

When this function is called, the execution is transferred to the error processing block. In other words, if the `RAISERROR()` function is called within the `BEGIN TRY` block, the execution switches to the `BEGIN CATCH` block:

Learn to generate custom error messages.


Before We Start

T-SQL Basics

Querying Multiple Tables

Grouping and Aggregation

Subqueries

T-SQL Fundamentals Assessment

Built-in Functions

T-SQL Programming Basics

Additional Programming Constructs

Course Comprehension Assessment

Conclusion

Raising and Throwing Errors

The `RAISERROR()` function

Example