Connecting to and integrating with SQL databases
We will start with an example that uses Microsoft SQL. First, open SQL Server Management Studio and create a database called MyCompany, with one table, Employees.
You can use the SQL script in the following code block to create the table with the relevant columns and data types for this example:
CREATE TABLE dbo.Employees ( Id int NOT NULL IDENTITY (1, 1), Name varchar(MAX) NOT NULL, Salary decimal(10, 2) NOT NULL, Address varchar(MAX) NOT NULL, City varchar(50) NOT NULL, Region varchar(50) NOT NULL, Country varchar(50) NOT NULL, Phone varchar(200) NOT NULL, PostalCode varchar(10) NOT NULL )
In the Employees table, we have set the Id column as an identity column, meaning...
