Gain insights into T-SQL syntax, table creation, data manipulation, and relationships. Delve into advanced constructs like stored procedures, functions, and triggers to enhance your database development skills.

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

When we assign a value of one type to a column that stores data of another type, MS SQL Server tries to perform a conversion and cast the value to the needed type. Let’s consider a table with one column of type `NVARCHAR`:

```SQL
CREATE TABLE ReferenceTable
(
    Data NVARCHAR(100)
);
```

If we try to insert a numeric value into the column above, an automatic conversion to `NVARCHAR` takes place:

CREATE DATABASE ReferenceDatabase;
USE ReferenceDatabase;

CREATE TABLE ReferenceTable
(
    Data NVARCHAR(100)
);

INSERT INTO dbo.ReferenceTable (Data)
VALUES (56), (23), (68); -- We put INT values here

-- INT values are converted and are inserted into NVARCHAR column
SELECT * FROM dbo.ReferenceTable;

import React from 'react';
import { shallow, configure } from 'enzyme';
import Adapter from 'enzyme-adapter-react-16';

configure({ adapter: new Adapter() });

import HelloWorld from './app';

var TestResult = function() {
    this.succeeded = false;
    this.reason = "";
    this.input = "";
    this.expected_output = "";
    this.actual_output = "";
}

export const executeTests = function() {

  var results = [];

  result = new TestResult();
  result.input = 'HelloWorld Component';
  result.expected_output = "span containing text 'Hello World'"

  let wrapper = shallow(<HelloWorld />);

  // Call your Challenge function here.

  let type = wrapper.type();
  let testSuccessful = true;
  let failureReason;

  if (type !== 'span') {
    testSuccessful = false;
    failureReason = "You need to render exactly one span HTML element";
  } else if (wrapper.props().children != "Hello World") {
     testSuccessful = false;
     failureReason = "You have rendered wrong message in your span element";
  }

  result.actual_output = wrapper.html();

  if (testSuccessful) {
    result.succeeded = true;
    result.reason = "Succeeded"
  } else {
    result.succeeded = false;
    result.reason = failureReason;
  }

  results.push(result);

  return results;
}


React

Dart

GoJS React

Typescript React

Vue.js

However, not all conversions will take place automatically. In some situations, we might need to use explicit conversion.

## The `CAST()` function

The easiest way to cast an object of one type to another is to use the `CAST()` function. It has the following syntax:

```SQL
CAST([Object we want to cast] AS [Target data type])
```

For example, if we want to convert an `NVARCHAR` value to `INT`, we could use the `CAST()` function like this:

```SQL
CAST('25' AS INT)
```

In the following example, we have a table with several columns in a `SELECT` query. We want to output all columns as a single `NVARCHAR` value. To make sure that concatenation is successful, we can cast all columns to `NVARCHAR` first and then add them together:

However, not all conversions will take place automatically. In some situations, we might need to use explicit conversion.

# The `CAST()` function

The easiest way to cast an object of one type to another is to use the `CAST()` function. It has the following syntax:

```SQL
CAST([Object we want to cast] AS [Target data type])
```

For example, if we want to convert an `NVARCHAR` value to `INT`, we could use the `CAST()` function like this:

```SQL
CAST('25' AS INT)
```

In the following example, we have a table with several columns in a `SELECT` query. We want to output all columns as a single `NVARCHAR` value. To make sure that concatenation is successful, we can cast all columns to `NVARCHAR` first and then add them together:

Learn about casting and converting a value to a different data type in T-SQL.

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

Casting and Conversion

The `CAST()` function

T-SQL Fundamentals Assessment

Course Comprehension Assessment

Casting and Conversion

The CAST() function

The `CAST()` function