CreateDatabase_DbBulkCopy.sql

USE [master]
GO

/****** Object:  Database [DbBulkCopy]    Script Date: 2026/08/07 08:30:46 ******/
CREATE DATABASE [DbBulkCopy]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'DbBulkCopy', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\DbBulkCopy.mdf' , SIZE = 139264KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'DbBulkCopy_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\DbBulkCopy_log.ldf' , SIZE = 663552KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
 WITH CATALOG_COLLATION = DATABASE_DEFAULT
GO

USE [DbBulkCopy]
GO

/****** Object:  Table [dbo].[SampleData]    Script Date: 2026/08/07 08:31:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[EmployeeData](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[FirstName] [nvarchar](100) NULL,
	[LastName] [nvarchar](100) NULL,
	[Department] [nvarchar](100) NULL,
	[City] [nvarchar](100) NULL,
	[Country] [nvarchar](100) NULL,
	[HireDate] [date] NULL,
	[Age] [int] NULL,
	[BaseSalary] [decimal](18, 2) NULL,
	[Bonus] [decimal](18, 2) NULL,
	[HoursWorked] [int] NULL,
	[HourlyRate] [decimal](9, 2) NULL,
	[Rating] [decimal](3, 1) NULL,
	[ProjectsDone] [int] NULL,
	[SickDays] [int] NULL,
	[VacationDays] [int] NULL,
	[IsActive] [bit] NULL,
	[TaxRate] [decimal](5, 4) NULL,
	[Deductions] [decimal](18, 2) NULL,
	[SalesQ1] [decimal](18, 2) NULL,
	[SalesQ2] [decimal](18, 2) NULL,
	[SalesQ3] [decimal](18, 2) NULL,
	[SalesQ4] [decimal](18, 2) NULL,
	[TotalCompensation] [decimal](18, 2) NULL,
	[TotalAnnualSales] [decimal](18, 2) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO