Dela via


Creating the HumanResources.myTeam Table

Many of the code examples in Importing and Exporting Bulk Data require a special-purpose test table named myTeam. Before you can run the examples, you must create the myTeam table in the HumanResources schema of the AdventureWorks2008R2 database.

Note

AdventureWorks2008R2 is one of the sample databases in SQL Server 2008. Adventure Works Cycles is a fictional manufacturing company used to demonstrate database concepts and scenarios. For more information about this database, see AdventureWorks2008R2 Sample Databases.

The myTeam table is contains the following columns.

Column

Data type

Nullability

Description

EmployeeID

smallint

Not null

Primary key for the rows. Employee ID of a member of my team.

Name

nvarchar(50)

Not null

Name of a member of my team.

Title

nvarchar(50)

Nullable

Title the employee performs on my team.

Background

nvarchar(50)

Not null

Date and time the row was last updated. (Default)

To create HumanResources.myTeam

  • Use the following Transact-SQL statements:

    --Create HumanResources.MyTeam: 
    USE AdventureWorks2008R2;
    GO
    CREATE TABLE HumanResources.myTeam 
    (EmployeeID smallint NOT NULL,
    Name nvarchar(50) NOT NULL,
    Title nvarchar(50) NULL,
    Background nvarchar(50) NOT NULL DEFAULT ''
    );
    GO
    

To populate HumanResources.myTeam

  • Execute following INSERT statements to populate the table with two rows:

    USE AdventureWorks2008R2;
    GO
    INSERT INTO HumanResources.myTeam(EmployeeID,Name,Title,Background)
       VALUES(77,'Mia Doppleganger','Administrative Assistant','Microsoft Office');
    GO
    INSERT INTO HumanResources.myTeam(EmployeeID,Name,Title,Background)
       VALUES(49,'Hirum Mollicat','I.T. Specialist','Report Writing and Data Mining');
    GO
    

    Note

    These statements skip the fourth column, Background. This has a default value. Skipping this column causes this INSERT statement to leave this column blank.