1. 前言
歡迎來到 SQL 學習的第一站！要掌握資料庫語言，僅僅閱讀語法是不夠的，實戰練習才是內化技術的捷徑。為了讓你在練習查詢、更新或刪除指令時，能獲得預期且具參考價值的結果，擁有一個「標準化測試資料庫」至關重要。
請放下對 SQL Server Management Studio (SSMS) 複雜介面的恐懼。這套指南將像導師一樣，陪你一步步建立起穩健的實驗環境。
2. 建立空白範例資料庫
在存入任何資料之前，我們必須先在SSMS中規劃出一個獨立的空間。這個空間就像是一個空的檔案夾，它是所有後續操作的物理基礎。
• 操作指令： 請在SSMS的「物件總管」中點擊右鍵建立新資料庫。
• 關鍵名稱： 請務必將資料庫名稱設定為 demodb。
專家觀點： 在資料庫管理中，先建立一個「空白容器」是所有後續操作的基礎。這就像是在蓋房子前，必須先圈定一塊土地，確保所有的結構與資源都有處安放。
3. 建立範例資料表
有了資料庫後，下一步是建立「資料表結構 (Schema)」。
你可以將結構比喻為「資料存儲的骨幹」，或者是「遊戲規則」。它定義了每一筆資料的屬性（例如：生日欄位必須是日期格式，而不能輸入文字），這正是保護商務邏輯的第一道邊界。
3.1 關鍵操作步驟
為了確保腳本執行在正確的位置，請遵循以下專業流程：
1. 開啟查詢視窗： 在 SSMS 上方工具列點擊「新增查詢 (New Query)」。
2. 切換資料庫： 在視窗左上角的「可用資料庫下拉選單 (Available Databases)」中，將 master 切換為剛剛建立的 demodb。這能避免腳本被錯誤地執行在系統資料庫中。
3. 執行腳本： 載入並執行名為 SQLDemoTable–範例資料庫資料表 的腳本。
3.2 為什麼「精確執行結構腳本」很重要？
精確地部署 Schema 對於維護「資料完整性」有兩大關鍵好處：
• 標準化規範： 確保如員工、產品、訂單等每一張表，都擁有統一的欄位與資料格式。
• 邏輯一致性： 透過預先定義的限制（Constraints），讓商務邏輯能在穩定的規則下運行。
3.3 執行範例資料庫資料表腳本程式
一個只有結構的資料庫就像一間沒有商品的超市。為了模擬真實的業務情境，我們必須注入「測試資料 (Initial Data)」。
在 demodb 建立後，執行 SQLDemoTable–範例資料庫資料表 腳本程式 ：
建立範例資料表格語法
DROP TABLE IF EXISTS [dbo].[Customers]
DROP TABLE IF EXISTS [dbo].[CustomersType]
DROP TABLE IF EXISTS [dbo].[Departments]
DROP TABLE IF EXISTS [dbo].[Employees]
DROP TABLE IF EXISTS [dbo].[Inventorys]
DROP TABLE IF EXISTS [dbo].[InventorysDetail]
DROP TABLE IF EXISTS [dbo].[InventorysType]
DROP TABLE IF EXISTS [dbo].[InvMaster]
DROP TABLE IF EXISTS [dbo].[InvDetail]
DROP TABLE IF EXISTS [dbo].[Overtimes]
DROP TABLE IF EXISTS [dbo].[Places]
DROP TABLE IF EXISTS [dbo].[Products]
DROP TABLE IF EXISTS [dbo].[ProductsType]
DROP TABLE IF EXISTS [dbo].[ProductsPrice]
DROP TABLE IF EXISTS [dbo].[Purchases]
DROP TABLE IF EXISTS [dbo].[PurchasesDetail]
DROP TABLE IF EXISTS [dbo].[Sales]
DROP TABLE IF EXISTS [dbo].[SalesDetail]
DROP TABLE IF EXISTS [dbo].[SalesRecord]
DROP TABLE IF EXISTS [dbo].[SchoolsKaohsiung]
DROP TABLE IF EXISTS [dbo].[SchoolsTaichung]
DROP TABLE IF EXISTS [dbo].[SchoolsTaipei]
DROP TABLE IF EXISTS [dbo].[Scores]
DROP TABLE IF EXISTS [dbo].[Subjects]
DROP TABLE IF EXISTS [dbo].[Students]
DROP TABLE IF EXISTS [dbo].[Teachers]
DROP TABLE IF EXISTS [dbo].[Units]
DROP TABLE IF EXISTS [dbo].[Users]
DROP TABLE IF EXISTS [dbo].[Vendors]
DROP TABLE IF EXISTS [dbo].[VendorType]
DROP TABLE IF EXISTS [dbo].[Warehouses]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Customers](
[Id] [int] IDENTITY(1,1) NOT NULL,
[IsEnabled] [bit] NOT NULL,
[TypeNo] [nvarchar](50) NULL,
[CustomerNo] [nvarchar](50) NULL,
[ShortName] [nvarchar](50) NULL,
[CustomerName] [nvarchar](250) NULL,
[CompanyTelphone] [nvarchar](50) NULL,
[CompanyFax] [nvarchar](50) NULL,
[CompanyAddress] [nvarchar](250) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Customers] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Customers_CustomerNo] ON [dbo].[Customers]
(
[CustomerNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CustomersType](
[Id] [int] IDENTITY(1,1) NOT NULL,
[TypeNo] [nvarchar](50) NULL,
[TypeName] [nvarchar](50) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_CustomersType] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_CustomersType_TypeNo] ON [dbo].[CustomersType]
(
[TypeNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Departments](
[Id] [int] IDENTITY(1,1) NOT NULL,
[DeptNo] [nvarchar](50) NULL,
[DeptName] [nvarchar](50) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Departments] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Departments_DeptNo] ON [dbo].[Departments]
(
[DeptNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Employees](
[Id] [int] IDENTITY(1,1) NOT NULL,
[EmpNo] [nvarchar](50) NULL,
[EmpName] [nvarchar](50) NULL,
[GenderCode] [nvarchar](50) NULL,
[BossNo] [nvarchar](50) NULL,
[DeptNo] [nvarchar](50) NULL,
[EdicationCode] [nvarchar](50) NULL,
[Birthday] [date] NULL,
[OnboardDate] [date] NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Employees_EmpNo] ON [dbo].[Employees]
(
[EmpNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Warehouses](
[Id] [int] IDENTITY(1,1) NOT NULL,
[WarehouseNo] [nvarchar](50) NULL,
[WarehouseName] [nvarchar](50) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Warehouses] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Warehouses_WarehouseNo] ON [dbo].[Warehouses]
(
[WarehouseNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Inventorys](
[Id] [int] IDENTITY(1,1) NOT NULL,
[TypeNo] [nvarchar](50) NULL,
[SheetCode] [nvarchar](50) NULL,
[SheetNo] [nvarchar](50) NULL,
[SheetDate] [date] NULL,
[WarehouseNo] [nvarchar](50) NULL,
[TargetNo] [nvarchar](50) NULL,
[TargetName] [nvarchar](50) NULL,
[HandleNo] [nvarchar](50) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Inventorys] 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
CREATE TABLE [dbo].[InventorysDetail](
[Id] [int] IDENTITY(1,1) NOT NULL,
[ParentId] [int] NULL,
[ProductNo] [nvarchar](50) NULL,
[Qty] [int] NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_InventorysDetail] 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
CREATE TABLE [dbo].[InventorysType](
[Id] [int] IDENTITY(1,1) NOT NULL,
[TypeNo] [nvarchar](50) NULL,
[TypeName] [nvarchar](50) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_InventorysType] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_InventorysType_TypeNo] ON [dbo].[InventorysType]
(
[TypeNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[InvMaster](
[Id] [int] IDENTITY(1,1) NOT NULL,
[ProductNo] [nvarchar](50) NULL,
[Qty] [int] NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_InvMaster] 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
CREATE TABLE [dbo].[InvDetail](
[Id] [int] IDENTITY(1,1) NOT NULL,
[WareHouseNo] [nvarchar](50) NULL,
[ProductNo] [nvarchar](50) NULL,
[Qty] [int] NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_InvDetail] 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
CREATE TABLE [dbo].[Overtimes](
[Id] [int] IDENTITY(1,1) NOT NULL,
[SheetNo] [nvarchar](50) NULL,
[SheetDate] [date] NULL,
[DeptName] [nvarchar](50) NULL,
[Amounts] [int] NULL,
[Hours] [int] NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Overtimes] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Overtimes_SheetNo] ON [dbo].[Overtimes]
(
[SheetNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Places](
[Id] [int] IDENTITY(1,1) NOT NULL,
[PlaceNo] [nvarchar](50) NULL,
[PlaceName] [nvarchar](50) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Places] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Places_PlaceNo] ON [dbo].[Places]
(
[PlaceNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Products](
[Id] [int] IDENTITY(1,1) NOT NULL,
[ProductNo] [nvarchar](50) NULL,
[ProductName] [nvarchar](50) NULL,
[ProductSpec] [nvarchar](250) NULL,
[VendorNo] [nvarchar](50) NULL,
[TypeNo] [nvarchar](50) NULL,
[UnitNo] [nvarchar](50) NULL,
[PlaceNo] [nvarchar](50) NULL,
[SubjectNo] [nvarchar](50) NULL,
[SalePrice] [int] NULL,
[DiscountPrice] [int] NULL,
[LowPrice] [int] NULL,
[HighPrice] [int] NULL,
[CostPrice] [int] NULL,
[ExpiredDay] [int] NULL,
[SafetyQty] [int] NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Products] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Products_ProductNo] ON [dbo].[Products]
(
[ProductNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ProductsType](
[Id] [int] IDENTITY(1,1) NOT NULL,
[ParentId] [int] NULL,
[LevelNo] [int] NULL,
[TypeNo] [nvarchar](50) NULL,
[TypeName] [nvarchar](50) NULL,
[RouteName] [nvarchar](250) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_ProductsType] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_ProductsType_TypeNo] ON [dbo].[ProductsType]
(
[TypeNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Purchases](
[Id] [int] IDENTITY(1,1) NOT NULL,
[SheetNo] [nvarchar](50) NULL,
[SheetDate] [date] NULL,
[UserNo] [nvarchar](50) NULL,
[VendorNo] [nvarchar](50) NULL,
[TaxCode] [nvarchar](50) NULL,
[Amounts] [int] NULL,
[Taxs] [int] NULL,
[Totals] [int] NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Purchases] 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
CREATE TABLE [dbo].[PurchasesDetail](
[Id] [int] IDENTITY(1,1) NOT NULL,
[ParentId] [int] NULL,
[ProductNo] [nvarchar](50) NULL,
[Qty] [decimal](18, 4) NULL,
[Price] [decimal](18, 4) NULL,
[Amount] [decimal](18, 4) NULL,
[DeliveryDate] [date] NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_PurchasesDetail] 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
ALTER TABLE [dbo].[PurchasesDetail] ADD CONSTRAINT [DF_PurchasesDetail_Qty] DEFAULT ((1)) FOR [Qty]
GO
CREATE TABLE [dbo].[Sales](
[Id] [int] IDENTITY(1,1) NOT NULL,
[SheetNo] [nvarchar](50) NULL,
[SheetDate] [nvarchar](50) NULL,
[UserNo] [nvarchar](50) NULL,
[CustomerNo] [nvarchar](50) NULL,
[Amounts] [int] NULL,
[Taxs] [int] NULL,
[Totals] [int] NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Sales] 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
CREATE TABLE [dbo].[SalesDetail](
[Id] [int] IDENTITY(1,1) NOT NULL,
[ParentId] [int] NULL,
[ProductNo] [nvarchar](50) NULL,
[Qty] [decimal](18, 4) NULL,
[Price] [decimal](18, 4) NULL,
[Amount] [decimal](18, 4) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_SalesDetail] 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
CREATE TABLE [dbo].[SalesRecord](
[Id] [int] IDENTITY(1,1) NOT NULL,
[SaleDate] [date] NULL,
[ProductNo] [nvarchar](50) NULL,
[SaleQty] [int] NULL,
[SalePrice] [int] NULL,
[SaleAmount] [int] NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_SalesRecord] PRIMARY KEY NONCLUSTERED
(
[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
CREATE CLUSTERED INDEX [IX_SalesRecord_SaleDate_ProductNo] ON [dbo].[SalesRecord]
(
[SaleDate] ASC,
[ProductNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[SchoolsKaohsiung](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Grade] [int] NULL,
[IDNo] [nvarchar](50) NULL,
[FullName] [nvarchar](50) NULL,
[Gender] [nvarchar](50) NULL,
CONSTRAINT [PK_SchoolsKaohsiung] 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
CREATE TABLE [dbo].[SchoolsTaichung](
[Id] [int] IDENTITY(1,1) NOT NULL,
[GradeYear] [int] NULL,
[StudIDNo] [nvarchar](50) NULL,
[StudName] [nvarchar](50) NULL,
[StudGender] [nvarchar](50) NULL,
CONSTRAINT [PK_SchoolsTaichung] 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
CREATE TABLE [dbo].[SchoolsTaipei](
[Id] [int] IDENTITY(1,1) NOT NULL,
[GradeNo] [int] NULL,
[StudentID] [nvarchar](50) NULL,
[StudentName] [nvarchar](50) NULL,
[GenderCode] [nvarchar](50) NULL,
CONSTRAINT [PK_SchoolsTaipei] 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
CREATE TABLE [dbo].[Scores](
[Id] [int] IDENTITY(1,1) NOT NULL,
[ExamName] [nvarchar](50) NULL,
[StudentNo] [nvarchar](50) NULL,
[EnglishScore] [int] NOT NULL,
[ChineseScore] [int] NOT NULL,
[MathScore] [int] NOT NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Scores] 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
CREATE TABLE [dbo].[StandardPrice]
(
[ProductNo] NVARCHAR(10) NOT NULL,
[StandardPrice] DECIMAL(18,2) NOT NULL,
[Remark] NVARCHAR(255) NULL,
CONSTRAINT [PK_StandardPrice]
PRIMARY KEY CLUSTERED ([ProductNo])
);
GO
CREATE TABLE [dbo].[ProductsPrice](
[Id] [int] IDENTITY(1,1) NOT NULL,
[ProductNo] [nvarchar](50) NULL,
[StandardPrice] [int] NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_ProductsPrice] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_ProductsPrice_ProductNo] ON [dbo].[ProductsPrice]
(
[ProductNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Subjects](
[Id] [int] IDENTITY(1,1) NOT NULL,
[SubjectNo] [nvarchar](50) NULL,
[SubjectName] [nvarchar](50) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Subjects] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Subjects_SubjectNo] ON [dbo].[Subjects]
(
[SubjectNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Students](
[Id] [int] IDENTITY(1,1) NOT NULL,
[StudentNo] [nvarchar](50) NULL,
[StudentName] [nvarchar](50) NULL,
[Password] [nvarchar](50) NULL,
[TeacherNo] [nvarchar](50) NULL,
[IdentityNo] [nvarchar](50) NULL,
[Birthday] [date] NOT NULL,
[ContactEmail] [nvarchar](250) NULL,
[BlogUrl] [nvarchar](250) NULL,
[Scores] [int] NOT NULL,
[Ranks] [int] NOT NULL,
CONSTRAINT [PK_dbo.Students] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Students_StudentNo] ON [dbo].[Students]
(
[StudentNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Teachers](
[Id] [int] IDENTITY(1,1) NOT NULL,
[TeacherNo] [nvarchar](50) NULL,
[TeacherName] [nvarchar](50) NULL,
CONSTRAINT [PK_dbo.Teachers] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Teachers_TeacherNo] ON [dbo].[Teachers]
(
[TeacherNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Units](
[Id] [int] IDENTITY(1,1) NOT NULL,
[UnitNo] [nvarchar](50) NULL,
[UnitName] [nvarchar](50) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Units] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Units_UnitNo] ON [dbo].[Units]
(
[UnitNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Users](
[Id] [int] IDENTITY(1,1) NOT NULL,
[IsEnabled] [bit] NOT NULL,
[UserCode] [nvarchar](50) NULL,
[UserNo] [nvarchar](50) NULL,
[UserName] [nvarchar](50) NULL,
[UserPassword] [nvarchar](250) NULL,
[UserEmail] [nvarchar](250) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Users] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Users_UserNo] ON [dbo].[Users]
(
[UserNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Vendors](
[Id] [int] IDENTITY(1,1) NOT NULL,
[IsEnabled] [bit] NOT NULL,
[TypeNo] [nvarchar](50) NULL,
[VendorNo] [nvarchar](50) NULL,
[ShortName] [nvarchar](50) NULL,
[VendorName] [nvarchar](250) NULL,
[CompanyTelphone] [nvarchar](50) NULL,
[CompanyFax] [nvarchar](50) NULL,
[CompanyAddress] [nvarchar](250) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_Vendors] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_Vendors_VendorNo] ON [dbo].[Vendors]
(
[VendorNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
CREATE TABLE [dbo].[VendorType](
[Id] [int] IDENTITY(1,1) NOT NULL,
[TypeNo] [nvarchar](50) NULL,
[TypeName] [nvarchar](50) NULL,
[Remark] [nvarchar](250) NULL,
CONSTRAINT [PK_VendorType] PRIMARY KEY NONCLUSTERED
(
[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
CREATE UNIQUE CLUSTERED INDEX [IX_VendorType_TypeNo] ON [dbo].[VendorType]
(
[TypeNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO 
4. 建立範例資料表資料
如果說 Schema 是規則，那麼測試資料就是「參與遊戲的玩家」。高品質的開發環境必須落實「結構與資料同步部署」，這能確保你在寫 SQL 指令時，是在一個具備邏輯意義的環境中進行驗證。
4.1 執行步驟
在確認選取 sqldb 的狀態下，執行 SQLDemoData–範例資料庫資料表資料 腳本。
測試資料 (Initial Data) 是模擬真實業務情境的關鍵。高品質的開發環境必須落實「結構與資料同步部署」，以確保開發與測試團隊能在具備邏輯意義的環境中驗證應用程式。
針對資料初始化，執行 SQLDemoData–範例資料庫資料表資料 腳本程式 ：
建立範例資料語法
TRUNCATE TABLE [dbo].[Employees]
TRUNCATE TABLE [dbo].[Customers]
TRUNCATE TABLE [dbo].[CustomersType]
TRUNCATE TABLE [dbo].[Inventorys]
TRUNCATE TABLE [dbo].[InventorysDetail]
TRUNCATE TABLE [dbo].[InventorysType]
TRUNCATE TABLE [dbo].[InvMaster]
TRUNCATE TABLE [dbo].[InvDetail]
TRUNCATE TABLE [dbo].[Overtimes]
TRUNCATE TABLE [dbo].[Places]
TRUNCATE TABLE [dbo].[Products]
TRUNCATE TABLE [dbo].[ProductsType]
TRUNCATE TABLE [dbo].[Purchases]
TRUNCATE TABLE [dbo].[PurchasesDetail]
TRUNCATE TABLE [dbo].[Sales]
TRUNCATE TABLE [dbo].[SalesDetail]
TRUNCATE TABLE [dbo].[SalesRecord]
TRUNCATE TABLE [dbo].[SchoolsKaohsiung]
TRUNCATE TABLE [dbo].[SchoolsTaichung]
TRUNCATE TABLE [dbo].[SchoolsTaipei]
TRUNCATE TABLE [dbo].[Scores]
TRUNCATE TABLE [dbo].[StandardPrice]
TRUNCATE TABLE [dbo].[Subjects]
TRUNCATE TABLE [dbo].[Students]
TRUNCATE TABLE [dbo].[Teachers]
TRUNCATE TABLE [dbo].[Units]
TRUNCATE TABLE [dbo].[Users]
TRUNCATE TABLE [dbo].[Vendors]
TRUNCATE TABLE [dbo].[VendorType]
TRUNCATE TABLE [dbo].[Warehouses]
TRUNCATE TABLE [dbo].[Departments]
GO
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E001', N'馮冠宇', N'M', N'', N'D01', N'D', CAST(N'2005-08-08' AS Date), CAST(N'2021-08-03' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E002', N'陳淑吟', N'F', N'E001', N'D01', N'C', CAST(N'1999-09-16' AS Date), CAST(N'2021-05-16' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E003', N'林聖如', N'M', N'E001', N'D01', N'E', CAST(N'1996-09-19' AS Date), CAST(N'2008-09-20' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E004', N'趙元新', N'M', N'E001', N'D08', N'C', CAST(N'1990-08-04' AS Date), CAST(N'2007-08-18' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E005', N'林怡雯', N'F', N'E001', N'D02', N'D', CAST(N'1996-02-05' AS Date), CAST(N'2010-07-19' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E006', N'葉立偉', N'M', N'E001', N'D01', N'B', CAST(N'1996-08-03' AS Date), CAST(N'2001-07-19' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E007', N'黃仁杰', N'M', N'E002', N'D06', N'C', CAST(N'1990-03-05' AS Date), CAST(N'2017-07-12' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E008', N'柯志祥', N'M', N'E002', N'D01', N'C', CAST(N'2004-06-20' AS Date), CAST(N'2011-05-06' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E009', N'李欣儀', N'F', N'E002', N'D03', N'C', CAST(N'1999-11-18' AS Date), CAST(N'2000-08-14' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E010', N'陳怡秀', N'F', N'E002', N'D05', N'A', CAST(N'1994-08-15' AS Date), CAST(N'2014-09-13' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E011', N'許雅士', N'M', N'E002', N'D03', N'E', CAST(N'1992-11-12' AS Date), CAST(N'2017-05-06' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E012', N'李怡苓', N'F', N'E003', N'D04', N'C', CAST(N'1991-12-04' AS Date), CAST(N'2000-01-31' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E013', N'汪東卉', N'F', N'E003', N'D01', N'D', CAST(N'1996-10-08' AS Date), CAST(N'2000-03-11' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E014', N'何平淑', N'F', N'E003', N'D07', N'D', CAST(N'2003-04-02' AS Date), CAST(N'2015-10-01' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E015', N'曾欣樺', N'F', N'E003', N'D04', N'C', CAST(N'2000-05-07' AS Date), CAST(N'2000-12-10' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E016', N'林美惠', N'F', N'E003', N'D02', N'B', CAST(N'2005-05-07' AS Date), CAST(N'2013-08-31' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E017', N'楊雅亦', N'F', N'E003', N'D08', N'C', CAST(N'1995-08-23' AS Date), CAST(N'2021-06-21' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E018', N'李美宜', N'F', N'E003', N'D03', N'C', CAST(N'2003-03-30' AS Date), CAST(N'2017-02-23' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E019', N'陳旺貞', N'F', N'E003', N'D06', N'D', CAST(N'1994-02-10' AS Date), CAST(N'2010-03-27' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E020', N'林雅琳', N'F', N'E003', N'D02', N'C', CAST(N'1996-02-04' AS Date), CAST(N'2022-03-23' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E021', N'孟育瑋', N'M', N'E004', N'D05', N'B', CAST(N'2003-01-07' AS Date), CAST(N'2019-03-19' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E022', N'林俊豪', N'M', N'E004', N'D01', N'D', CAST(N'1997-01-07' AS Date), CAST(N'2017-12-06' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E023', N'張瑞峰', N'M', N'E004', N'D09', N'B', CAST(N'1992-09-21' AS Date), CAST(N'2014-10-04' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E024', N'賴維哲', N'M', N'E004', N'D07', N'D', CAST(N'1996-04-15' AS Date), CAST(N'2018-01-03' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E025', N'許軒豪', N'M', N'E005', N'D01', N'C', CAST(N'1990-03-18' AS Date), CAST(N'2008-09-05' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E026', N'孫合生', N'M', N'E005', N'D01', N'D', CAST(N'1993-08-10' AS Date), CAST(N'2009-09-19' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E027', N'危軍麟', N'M', N'E005', N'D04', N'A', CAST(N'1994-08-19' AS Date), CAST(N'2016-06-08' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E028', N'顧誠均', N'M', N'E005', N'D01', N'D', CAST(N'2002-12-06' AS Date), CAST(N'2000-12-26' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E029', N'毛美珍', N'F', N'E005', N'D02', N'C', CAST(N'1997-06-16' AS Date), CAST(N'2012-09-21' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E030', N'曾于珊', N'F', N'E006', N'D03', N'E', CAST(N'1991-06-06' AS Date), CAST(N'2009-12-23' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E031', N'邱淑貞', N'F', N'E006', N'D06', N'D', CAST(N'1996-08-11' AS Date), CAST(N'2007-06-30' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E032', N'鄭雅惠', N'F', N'E006', N'D05', N'C', CAST(N'1999-09-14' AS Date), CAST(N'2017-10-29' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E033', N'戴維哲', N'M', N'E007', N'D09', N'C', CAST(N'1996-08-25' AS Date), CAST(N'2014-08-24' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E034', N'林宗中', N'M', N'E007', N'D10', N'B', CAST(N'2001-03-14' AS Date), CAST(N'2020-02-14' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E035', N'林嘉瑤', N'F', N'E007', N'D03', N'C', CAST(N'2004-08-02' AS Date), CAST(N'2004-04-24' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E036', N'吳光竹', N'M', N'E008', N'D01', N'D', CAST(N'1996-07-18' AS Date), CAST(N'2014-11-10' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E037', N'林盈鑫', N'M', N'E008', N'D03', N'D', CAST(N'2000-12-23' AS Date), CAST(N'2002-05-21' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E038', N'蔡志均', N'M', N'E008', N'D01', N'C', CAST(N'2003-12-08' AS Date), CAST(N'2020-01-05' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E039', N'王柏勳', N'M', N'E008', N'D04', N'C', CAST(N'1992-10-20' AS Date), CAST(N'2021-10-12' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E040', N'吳欣全', N'M', N'E009', N'D07', N'C', CAST(N'2001-01-29' AS Date), CAST(N'2000-12-24' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E041', N'王雅音', N'F', N'E009', N'D02', N'C', CAST(N'1996-07-20' AS Date), CAST(N'2017-10-13' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E042', N'劉禮帆', N'M', N'E009', N'D06', N'C', CAST(N'1997-03-25' AS Date), CAST(N'2010-06-30' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E043', N'盧家夢', N'F', N'E010', N'D05', N'C', CAST(N'1992-10-18' AS Date), CAST(N'2016-04-15' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E044', N'林紋禾', N'M', N'E010', N'D10', N'C', CAST(N'2001-02-12' AS Date), CAST(N'2009-06-26' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E045', N'賴志杰', N'M', N'E010', N'D07', N'C', CAST(N'1997-04-07' AS Date), CAST(N'2017-08-01' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E046', N'林雅雯', N'F', N'E011', N'D08', N'C', CAST(N'2003-08-29' AS Date), CAST(N'2015-05-01' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E047', N'趙林文', N'M', N'E011', N'D01', N'C', CAST(N'2003-07-09' AS Date), CAST(N'2002-02-07' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E048', N'吳宜修', N'M', N'E012', N'D03', N'C', CAST(N'2002-01-14' AS Date), CAST(N'2008-02-02' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E049', N'黃建宏', N'M', N'E012', N'D05', N'C', CAST(N'1997-08-04' AS Date), CAST(N'2003-08-14' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E050', N'黃倫政', N'M', N'E013', N'D10', N'C', CAST(N'1997-10-11' AS Date), CAST(N'2001-12-25' AS Date), N'')
INSERT [dbo].[Employees] ([EmpNo], [EmpName], [GenderCode], [BossNo], [DeptNo], [EdicationCode], [Birthday], [OnboardDate], [Remark]) VALUES (N'E051', N'許禎順', N'M', N'E013', N'D01', N'C', CAST(N'1998-02-25' AS Date), CAST(N'2017-12-21' AS Date), N'')
GO
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH001', N'和喬-1廠', N'和喬科技股份有限公司-一廠', N'03-5770776', N'03-5785130', N'新竹市科學園區研新一路8號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'B', N'ACH002', N'和喬-2廠', N'和喬科技股份有限公司-二廠', N'03-5770777', N'03-5794121', N'新竹市科學園區科技五路8號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'A', N'ACH003', N'聯華電子', N'聯華電子股份有限公司', N'03-5782258', N'03-5787380', N'新竹市科學工業園區力行二路3號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH004', N'啟昌紡織', N'啟昌紡織股份有限公司', N'037-221836', N'037-228457', N'苗栗縣銅鑼鄉中興工業區南區中興路10號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH005', N'昕琦-新竹廠', N'昕琦科技股份有限公司-新竹廠', N'03-5752822', N'03-5752823', N'新竹市光復路二段二巷45號1樓', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH006', N'勝創科技', N'勝創科技股份有限公司', N'03-5985288', N'03-5985998', N'新竹工業區光復路20號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH007', N'晶讚(國喬)', N'晶讚光電(股)公司-(國喬)', N'03-5637218', N'03-5794581', N'新竹市科學工業園區科技五路8號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH009', N'欣興(全懋)-竹科', N'欣興電子(股)公司新竹園區分公司', N'03-5995899', N'03-6992652', N'桃園縣龜山鄉工業區山鶯路177.179號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH010', N'欣興-新豐廠', N'欣興電子(股)公司-新豐廠', N'035-995899', N'035-905899', N'新竹縣新豐鄉中崙村290號(財會部or對帳單)', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH011', N'台燿科技', N'台燿科技股份有限公司', N'03-5551103', N'03-5553964', N'北市仁愛路3段26號11樓', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH012', N'達邁科技', N'達邁科技股份有限公司', N'03-5896088', N'03-5896099', N'新竹縣新埔鎮新芎路1段210號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH013', N'台灣微型', N'台灣微型影像股份有限公司', N'03-7585678', N'03-7586699', N'苗栗縣竹南鎮科學園區科西一路8號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH014', N'漢磊科技', N'漢磊科技股份有限公司', N'03-5779245', N'03-5770879', N'新竹科學園區創新一路18號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH015', N'光頡科技', N'光頡科技股份有限公司', N'03-5972931', N'03-5972935', N'新竹縣湖口鄉新竹工業區光復北路70號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'B', N'ACH016', N'頎邦(飛信)', N'頎邦科技(股)公司', N'03-5678788', N'03-5678789', N'新竹科學園區研發一路15號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH017', N'訊利電業', N'訊利電業股份有限公司', N'03-5822863', N'03-5835669', N'新竹縣竹東鎮學府路442號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH018', N'台灣超能源', N'台灣超能源股份有限公司', N'037-585666', N'037-584160', N'苗栗縣竹南鎮科北六路二號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'A', N'ACH019', N'矽格-北興廠', N'矽格股份有限公司-北興廠', N'03-5959213', N'03-5946657', N'新竹縣竹東鎮北興路一段436號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'A', N'ACH020', N'矽格-中興廠', N'矽格股份有限公司-中興廠', N'03-5824501', N'03-5823353', N'新竹縣竹東鎮中興路二段169巷11號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH021', N'眾晶科技', N'眾晶科技股份有限公司', N'03-5780011', N'03-5987345-1336', N'新竹市科學園區展業一路10號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH022', N'新日空調', N'新日空調工程股份有限公司 ', N'02-82262158', N'02-82261513', N'台北縣中和市建八路2號12樓之6', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH023', N'新利虹（利蝶）', N'新利虹科技股份有限公司', N'03-5979797', N'03-5982079', N'新竹縣湖口工業區工業五路23號 ', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH024', N'宏信科技', N'宏信科技工程股份有限公司', N'03-5551509 ', N'03-5535910 ', N'新竹縣竹北市縣政16街19號 ', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH025', N'新日光(旺能)', N'新日光能源科技(股)公司', N'03-5781999', N'03-5781799', N'新竹科學園區研發二路2號3F', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH026', N'詠倡科技', N'詠倡科技管理委員會', N'03-5160069', N'03-5160070', N'新竹市東區公道五路二段83號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH027', N'奇鈦科技', N'奇鈦科技股份有限公司', N'02-82215868', N'02-82215869', N'台北縣中和市立德街148巷58號7樓(對帳單&發票)', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH028', N'鈞隆工程', N'鈞隆工程有限公司', N'02-29652978', N'02-29608175', N'台北縣板橋市光華街39巷16號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH029', N'美商英特格', N'美商英特格有限公司台灣分公司', N'03-5982098', N'03-5982995', N'新竹市東區公道五路二段120號14樓', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH030', N'昇陽國際', N'昇陽國際半導體(股)公司', N'03-5648888', N'03-5670888', N'新竹市科學園區力行路6號6樓', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH031', N'正崴(竹科)', N'正崴精密工業(股)公司竹科研發分公司', N'03-5636565', N'', N'新竹市新竹科學工業園區研發一路8號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH032', N'誠創科技', N'誠創科技股份有限公司', N'035-979866', N'035-979833', N'新竹縣湖口鄉新興路458-3號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH033', N'中美矽晶(新竹廠)', N'中美矽晶製品股份有限公司', N'035-772233', N'035-781706', N'新竹市科學工業園區工業東二路八號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH034', N'中國電器', N'中國電器股份有限公司', N'03-5979901', N'03-5979907', N'新竹縣湖口鄉新竹工業園區光復北路81號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH035', N'東亞光電', N'東亞光電股份有限公司', N'03-5979901', N'03-5979907', N'新竹縣湖口鄉新竹工業園區光復北路81號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH036', N'寰邦科技', N'寰邦科技股份有限公司', N'035-981687', N'035-981807', N'新竹縣湖口鄉光復路75號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH037', N'裕奇工程', N'裕奇工程有限公司', N'03-5551509', N'03-5535910', N'新竹縣竹北市縣政16街19號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH038', N'科群', N'科群科技股份有限公司', N'03-6580517', N'03-6580501', N'新竹縣竹北市文興路一段142號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH039', N'清華大學', N'國立清華大學', N'03-5742612', N'35722366', N'新竹市光復路二段101號(工程四館)', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH040', N'力成-大同廠', N'力成科技(股)公司-大同廠', N'03-5980300', N'03-5372597', N'新竹縣湖口鄉新竹工業區大同路26號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH042', N'瑞昱', N'瑞昱半導體股份有限公司', N'03-5780211', N'03-5785249', N'新竹科學園區創新二路二號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH043', N'中美矽晶(竹南廠)', N'中美矽晶製品(股)公司竹南分公司', N'037-582533', N'037-580206', N'苗栗縣竹南鎮科中路21號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'B', N'ACH044', N'新日光-湖口廠', N'新日光能源科技(股)公司湖口分公司', N'03-5780011', N'035-982797', N'新竹縣湖口鄉新竹工業區文化路2號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH045', N'峻源', N'峻源股份有限公司', N'03-5875068', N'03-5171546', N'新竹縣關西鎮南新里新城1-1號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH046', N'福昌半導體', N'福昌半導體股份有限公司', N'03-5985889', N'03-5982700', N'新竹縣湖口鄉新竹工業區光復南路45號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH047', N'達輝光電', N'達輝光電股份有限公司', N'03-7587500', N'03-3909643', N'苗栗縣竹南科學園區科北二路3號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'A', N'ACH048', N'台英帝國', N'台英帝國菸草製造股份有限公司', N'037-539088', N'037-580303', N'苗栗縣竹南鎮群義路8號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'D', N'ACH049', N'隆達-竹南(威力盟)', N'隆達電子(股)公司竹南分公司', N'03-5977182', N'03-5323458', N'新竹縣湖口鄉新竹工業區光復北路20-1號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'A', N'ACH051', N'矽格-湖口廠', N'矽格股份有限公司-湖口廠', N'03-5971698', N'03-5974627', N'新竹縣竹東鎮北興路一段436號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'C', N'ACH054', N'博新開發', N'博新開發科技股份有限公司', N'03-5985695', N'03-5985735', N'新竹縣湖口鄉新竹工業區文化路26號', N'')
INSERT [dbo].[Customers] ([IsEnabled], [TypeNo], [CustomerNo], [ShortName], [CustomerName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'B', N'ACH055', N'榮創能源-湖口(先進)', N'榮創能源科技(股)公司', N'03-5976988', N'03-5970733', N'新竹縣湖口鄉新竹工業區工業五路13號', N'')
GO
INSERT [dbo].[CustomersType] ([TypeNo], [TypeName], [Remark]) VALUES (N'A', N'A級', N'每月拜訪3次')
INSERT [dbo].[CustomersType] ([TypeNo], [TypeName], [Remark]) VALUES (N'B', N'B級', N'每月拜訪2次')
INSERT [dbo].[CustomersType] ([TypeNo], [TypeName], [Remark]) VALUES (N'C', N'C級', N'每月拜訪1次')
INSERT [dbo].[CustomersType] ([TypeNo], [TypeName], [Remark]) VALUES (N'D', N'D級', N'每月拜訪1次')
GO
INSERT [dbo].[Departments] ([DeptNo], [DeptName], [Remark]) VALUES (N'D01', N'管理部', N'')
INSERT [dbo].[Departments] ([DeptNo], [DeptName], [Remark]) VALUES (N'D02', N'資訊部', N'')
INSERT [dbo].[Departments] ([DeptNo], [DeptName], [Remark]) VALUES (N'D03', N'財務部', N'')
INSERT [dbo].[Departments] ([DeptNo], [DeptName], [Remark]) VALUES (N'D04', N'品管部', N'')
INSERT [dbo].[Departments] ([DeptNo], [DeptName], [Remark]) VALUES (N'D05', N'總務部', N'')
INSERT [dbo].[Departments] ([DeptNo], [DeptName], [Remark]) VALUES (N'D06', N'行銷部', N'')
INSERT [dbo].[Departments] ([DeptNo], [DeptName], [Remark]) VALUES (N'D07', N'廠務部', N'')
INSERT [dbo].[Departments] ([DeptNo], [DeptName], [Remark]) VALUES (N'D08', N'人事部', N'')
INSERT [dbo].[Departments] ([DeptNo], [DeptName], [Remark]) VALUES (N'D09', N'研發部', N'')
INSERT [dbo].[Departments] ([DeptNo], [DeptName], [Remark]) VALUES (N'D10', N'生產部', N'')
GO
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202001001', CAST(N'2020-01-01' AS Date), N'研發部', 80000, 200, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202001002', CAST(N'2020-01-01' AS Date), N'管理部', 120000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202002001', CAST(N'2020-02-01' AS Date), N'研發部', 90000, 260, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202002002', CAST(N'2020-02-01' AS Date), N'財務部', 80000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202002003', CAST(N'2020-02-01' AS Date), N'管理部', 40000, 140, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202003001', CAST(N'2020-03-01' AS Date), N'人事部', 90000, 60, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202003002', CAST(N'2020-03-01' AS Date), N'財務部', 140000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202003003', CAST(N'2020-03-01' AS Date), N'研發部', 12000, 190, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202004001', CAST(N'2020-04-01' AS Date), N'管理部', 16000, 200, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202004002', CAST(N'2020-04-01' AS Date), N'人事部', 15000, 140, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202005001', CAST(N'2020-05-01' AS Date), N'研發部', 90000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202005002', CAST(N'2020-05-01' AS Date), N'財務部', 140000, 220, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202005003', CAST(N'2020-05-01' AS Date), N'管理部', 180000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202005004', CAST(N'2020-05-01' AS Date), N'人事部', 40000, 220, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202006002', CAST(N'2020-06-01' AS Date), N'財務部', 80000, 200, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202007001', CAST(N'2020-07-01' AS Date), N'財務部', 60000, 160, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202007002', CAST(N'2020-07-01' AS Date), N'人事部', 90000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202008001', CAST(N'2020-08-01' AS Date), N'研發部', 13000, 130, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202008002', CAST(N'2020-08-01' AS Date), N'管理部', 13000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202008003', CAST(N'2020-08-01' AS Date), N'人事部', 90000, 100, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202009001', CAST(N'2020-09-01' AS Date), N'研發部', 20000, 90, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202009002', CAST(N'2020-09-01' AS Date), N'人事部', 110000, 160, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202009003', CAST(N'2020-09-01' AS Date), N'管理部', 160000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202009004', CAST(N'2020-09-01' AS Date), N'研發部', 120000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202010001', CAST(N'2020-10-01' AS Date), N'財務部', 80000, 190, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202010002', CAST(N'2020-10-01' AS Date), N'人事部', 90000, 140, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202010003', CAST(N'2020-10-01' AS Date), N'財務部', 40000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202011001', CAST(N'2020-11-01' AS Date), N'研發部', 80000, 190, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202011002', CAST(N'2020-11-01' AS Date), N'管理部', 60000, 200, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202012001', CAST(N'2020-12-01' AS Date), N'人事部', 50000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202012002', CAST(N'2020-12-01' AS Date), N'人事部', 80000, 170, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202101001', CAST(N'2021-01-01' AS Date), N'研發部', 100000, 250, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202101002', CAST(N'2021-01-01' AS Date), N'管理部', 130000, 130, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202102001', CAST(N'2021-02-01' AS Date), N'人事部', 30000, 240, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202102002', CAST(N'2021-02-01' AS Date), N'研發部', 40000, 160, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202102003', CAST(N'2021-02-01' AS Date), N'管理部', 80000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202103001', CAST(N'2021-03-01' AS Date), N'人事部', 60000, 80, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202103002', CAST(N'2021-03-01' AS Date), N'研發部', 90000, 140, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202103003', CAST(N'2021-03-01' AS Date), N'財務部', 10000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202104001', CAST(N'2021-04-01' AS Date), N'研發部', 20000, 210, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202104002', CAST(N'2021-04-01' AS Date), N'財務部', 10000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202105001', CAST(N'2021-05-01' AS Date), N'人事部', 80000, 160, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202105002', CAST(N'2021-05-01' AS Date), N'研發部', 160000, 250, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202105003', CAST(N'2021-05-01' AS Date), N'管理部', 120000, 150, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202105004', CAST(N'2021-05-01' AS Date), N'財務部', 90000, 260, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202106002', CAST(N'2021-06-01' AS Date), N'財務部', 70000, 210, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202107001', CAST(N'2021-07-01' AS Date), N'人事部', 40000, 140, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202107002', CAST(N'2021-07-01' AS Date), N'研發部', 30000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202108001', CAST(N'2021-08-01' AS Date), N'財務部', 10000, 130, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202108002', CAST(N'2021-08-01' AS Date), N'人事部', 40000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202108003', CAST(N'2021-08-01' AS Date), N'研發部', 80000, 100, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202109001', CAST(N'2021-09-01' AS Date), N'管理部', 40000, 80, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202109002', CAST(N'2021-09-01' AS Date), N'財務部', 120000, 160, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202109003', CAST(N'2021-09-01' AS Date), N'管理部', 180000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202109004', CAST(N'2021-09-01' AS Date), N'財務部', 120000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202110001', CAST(N'2021-10-01' AS Date), N'研發部', 30000, 190, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202110002', CAST(N'2021-10-01' AS Date), N'人事部', 60000, 140, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202110003', CAST(N'2021-10-01' AS Date), N'研發部', 20000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202111001', CAST(N'2021-11-01' AS Date), N'財務部', 40000, 190, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202111002', CAST(N'2021-11-01' AS Date), N'研發部', 70000, 200, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202112001', CAST(N'2021-12-01' AS Date), N'財務部', 20000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202112002', CAST(N'2021-12-01' AS Date), N'財務部', 50000, 170, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202201001', CAST(N'2022-01-01' AS Date), N'管理部', 100000, 250, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202201002', CAST(N'2022-01-01' AS Date), N'研發部', 130000, 130, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202202001', CAST(N'2022-02-01' AS Date), N'財務部', 30000, 240, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202202002', CAST(N'2022-02-01' AS Date), N'研發部', 40000, 160, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202202003', CAST(N'2022-02-01' AS Date), N'管理部', 80000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202203001', CAST(N'2022-03-01' AS Date), N'財務部', 60000, 80, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202203002', CAST(N'2022-03-01' AS Date), N'研發部', 90000, 140, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202203003', CAST(N'2022-03-01' AS Date), N'管理部', 10000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202204001', CAST(N'2022-04-01' AS Date), N'研發部', 20000, 210, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202204002', CAST(N'2022-04-01' AS Date), N'管理部', 10000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202205001', CAST(N'2022-05-01' AS Date), N'人事部', 80000, 160, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202205002', CAST(N'2022-05-01' AS Date), N'管理部', 160000, 250, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202205003', CAST(N'2022-05-01' AS Date), N'研發部', 120000, 150, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202205004', CAST(N'2022-05-01' AS Date), N'財務部', 90000, 260, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202206002', CAST(N'2022-06-01' AS Date), N'管理部', 70000, 210, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202207001', CAST(N'2022-07-01' AS Date), N'研發部', 40000, 140, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202207002', CAST(N'2022-07-01' AS Date), N'管理部', 30000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202208001', CAST(N'2022-08-01' AS Date), N'人事部', 10000, 130, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202208002', CAST(N'2022-08-01' AS Date), N'研發部', 40000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202208003', CAST(N'2022-08-01' AS Date), N'管理部', 80000, 100, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202209001', CAST(N'2022-09-01' AS Date), N'人事部', 40000, 80, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202209002', CAST(N'2022-09-01' AS Date), N'研發部', 120000, 160, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202209003', CAST(N'2022-09-01' AS Date), N'管理部', 180000, 180, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202209004', CAST(N'2022-09-01' AS Date), N'人事部', 120000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202210001', CAST(N'2022-10-01' AS Date), N'財務部', 30000, 190, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202210002', CAST(N'2022-10-01' AS Date), N'管理部', 60000, 140, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202210003', CAST(N'2022-10-01' AS Date), N'研發部', 20000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202211001', CAST(N'2022-11-01' AS Date), N'人事部', 40000, 190, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202211002', CAST(N'2022-11-01' AS Date), N'管理部', 70000, 200, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202212001', CAST(N'2022-12-01' AS Date), N'人事部', 20000, 120, N'')
INSERT [dbo].[Overtimes] ([SheetNo], [SheetDate], [DeptName], [Amounts], [Hours], [Remark]) VALUES (N'202212002', CAST(N'2022-12-01' AS Date), N'管理部', 50000, 170, N'')
GO
INSERT [dbo].[Places] ([PlaceNo], [PlaceName], [Remark]) VALUES (N'01', N'常溫', NULL)
INSERT [dbo].[Places] ([PlaceNo], [PlaceName], [Remark]) VALUES (N'02', N'低溫', NULL)
INSERT [dbo].[Places] ([PlaceNo], [PlaceName], [Remark]) VALUES (N'03', N'室內', NULL)
GO
INSERT [dbo].[Products] ([ProductNo], [ProductName], [ProductSpec], [VendorNo], [TypeNo], [UnitNo], [PlaceNo], [SubjectNo], [SalePrice], [DiscountPrice], [LowPrice], [HighPrice], [CostPrice], [ExpiredDay], [SafetyQty], [Remark]) VALUES (N'D01', N'藍帶起司豬排', N'採用電宰生鮮肉部位製成', N'AN001', N'D', N'ST', N'04', N'P', 80, 0, 0, 0, 0, 30, 30, N'')
INSERT [dbo].[Products] ([ProductNo], [ProductName], [ProductSpec], [VendorNo], [TypeNo], [UnitNo], [PlaceNo], [SubjectNo], [SalePrice], [DiscountPrice], [LowPrice], [HighPrice], [CostPrice], [ExpiredDay], [SafetyQty], [Remark]) VALUES (N'D02', N'迷迭香草雞腿排', N'選用鮮嫩的雞腿肉', N'AN001', N'D', N'ST', N'01', N'P', 100, 0, 0, 0, 0, 0, 28, N'')
INSERT [dbo].[Products] ([ProductNo], [ProductName], [ProductSpec], [VendorNo], [TypeNo], [UnitNo], [PlaceNo], [SubjectNo], [SalePrice], [DiscountPrice], [LowPrice], [HighPrice], [CostPrice], [ExpiredDay], [SafetyQty], [Remark]) VALUES (N'D03', N'鐵路豬排', N'濃濃的懷舊古早味', N'AN001', N'D', N'ST', N'01', N'P', 120, 0, 0, 0, 0, 0, 50, N'')
INSERT [dbo].[Products] ([ProductNo], [ProductName], [ProductSpec], [VendorNo], [TypeNo], [UnitNo], [PlaceNo], [SubjectNo], [SalePrice], [DiscountPrice], [LowPrice], [HighPrice], [CostPrice], [ExpiredDay], [SafetyQty], [Remark]) VALUES (N'D04', N'德國香腸', N'嚴選上等豬肉', N'AN001', N'D', N'ST', N'03', N'P', 60, 0, 0, 0, 0, 0, 48, N'')
INSERT [dbo].[Products] ([ProductNo], [ProductName], [ProductSpec], [VendorNo], [TypeNo], [UnitNo], [PlaceNo], [SubjectNo], [SalePrice], [DiscountPrice], [LowPrice], [HighPrice], [CostPrice], [ExpiredDay], [SafetyQty], [Remark]) VALUES (N'D05', N'照燒雞腿肉', N'去骨雞腿肉4副、洋蔥半顆', N'AN002', N'D', N'ST', N'03', N'P', 80, 0, 0, 0, 0, 0, 31, N'')
INSERT [dbo].[Products] ([ProductNo], [ProductName], [ProductSpec], [VendorNo], [TypeNo], [UnitNo], [PlaceNo], [SubjectNo], [SalePrice], [DiscountPrice], [LowPrice], [HighPrice], [CostPrice], [ExpiredDay], [SafetyQty], [Remark]) VALUES (N'D06', N'蒜頭燒雞', N'雞腿肉兩副、蒜頭十瓣', N'AN002', N'D', N'ST', N'03', N'P', 400, 0, 0, 0, 0, 0, 87, N'')
INSERT [dbo].[Products] ([ProductNo], [ProductName], [ProductSpec], [VendorNo], [TypeNo], [UnitNo], [PlaceNo], [SubjectNo], [SalePrice], [DiscountPrice], [LowPrice], [HighPrice], [CostPrice], [ExpiredDay], [SafetyQty], [Remark]) VALUES (N'D07', N'吮指回味BBQ雞翅', N'雞翅八根，米酒一大匙、胡椒鹽少許', N'AN002', N'D', N'ST', N'01', N'P', 120, 0, 0, 0, 0, 0, 46, N'')
INSERT [dbo].[Products] ([ProductNo], [ProductName], [ProductSpec], [VendorNo], [TypeNo], [UnitNo], [PlaceNo], [SubjectNo], [SalePrice], [DiscountPrice], [LowPrice], [HighPrice], [CostPrice], [ExpiredDay], [SafetyQty], [Remark]) VALUES (N'D08', N'椒麻紅燒牛肉', N'牛肉軟嫩，湯頭鮮美', N'AN006', N'D', N'ST', N'01', N'P', 240, 0, 0, 0, 0, 0, 80, N'')
INSERT [dbo].[Products] ([ProductNo], [ProductName], [ProductSpec], [VendorNo], [TypeNo], [UnitNo], [PlaceNo], [SubjectNo], [SalePrice], [DiscountPrice], [LowPrice], [HighPrice], [CostPrice], [ExpiredDay], [SafetyQty], [Remark]) VALUES (N'D09', N'蔥蒜燉排骨', N'排骨3根、蔥一把、大蒜一大把', N'AN006', N'D', N'ST', N'04', N'P', 150, 0, 0, 0, 0, 0, 43, N'')
INSERT [dbo].[Products] ([ProductNo], [ProductName], [ProductSpec], [VendorNo], [TypeNo], [UnitNo], [PlaceNo], [SubjectNo], [SalePrice], [DiscountPrice], [LowPrice], [HighPrice], [CostPrice], [ExpiredDay], [SafetyQty], [Remark]) VALUES (N'D10', N'蒜香可樂豬蹄', N'軟中帶Q，好吃！', N'AN006', N'D', N'ST', N'04', N'P', 180, 0, 0, 0, 0, 0, 34, N'')
GO
INSERT [dbo].[ProductsType] ([ParentId], [LevelNo], [TypeNo], [TypeName], [RouteName], [Remark]) VALUES (0, 1, N'D', N'食品', N'食品', N'')
INSERT [dbo].[ProductsType] ([ParentId], [LevelNo], [TypeNo], [TypeName], [RouteName], [Remark]) VALUES (0, 1, N'E', N'電子', N'電子', N'')
INSERT [dbo].[ProductsType] ([ParentId], [LevelNo], [TypeNo], [TypeName], [RouteName], [Remark]) VALUES (0, 1, N'F', N'傢俱', N'傢俱', N'')
GO
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-01' AS Date), N'D02', 303, 60, 18180, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-01' AS Date), N'D06', 382, 400, 152800, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-01' AS Date), N'D10', 348, 180, 62640, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-02' AS Date), N'D01', 596, 80, 47680, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-02' AS Date), N'D02', 382, 100, 38200, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-02' AS Date), N'D03', 394, 90, 35460, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-02' AS Date), N'D04', 203, 60, 12180, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-03' AS Date), N'D02', 485, 180, 87300, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-03' AS Date), N'D06', 283, 400, 113200, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-03' AS Date), N'D09', 495, 150, 74250, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-08' AS Date), N'D06', 203, 400, 81200, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-08' AS Date), N'D07', 485, 120, 58200, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-09' AS Date), N'D06', 204, 400, 81600, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-09' AS Date), N'D08', 384, 160, 61440, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-12' AS Date), N'D01', 405, 80, 32400, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-12' AS Date), N'D03', 492, 120, 59040, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-18' AS Date), N'D03', 405, 120, 48600, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-18' AS Date), N'D09', 293, 150, 43950, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-21' AS Date), N'D01', 495, 80, 39600, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-21' AS Date), N'D03', 204, 120, 24480, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-25' AS Date), N'D10', 182, 180, 32760, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-26' AS Date), N'D02', 405, 100, 40500, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-26' AS Date), N'D06', 281, 400, 112400, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-28' AS Date), N'D07', 495, 120, 59400, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-28' AS Date), N'D08', 304, 240, 72960, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-31' AS Date), N'D02', 586, 100, 58600, N'')
INSERT [dbo].[SalesRecord] ([SaleDate], [ProductNo], [SaleQty], [SalePrice], [SaleAmount], [Remark]) VALUES (CAST(N'2022-01-31' AS Date), N'D05', 103, 80, 8240, N'')
GO
INSERT [dbo].[SchoolsKaohsiung] ([Grade], [IDNo], [FullName], [Gender]) VALUES (1, N'E0000000001', N'楊名正', N'M')
INSERT [dbo].[SchoolsKaohsiung] ([Grade], [IDNo], [FullName], [Gender]) VALUES (2, N'E0000000002', N'許孟君', N'M')
INSERT [dbo].[SchoolsKaohsiung] ([Grade], [IDNo], [FullName], [Gender]) VALUES (3, N'E0000000003', N'祖素蘭', N'F')
INSERT [dbo].[SchoolsKaohsiung] ([Grade], [IDNo], [FullName], [Gender]) VALUES (4, N'E0000000004', N'林逸彬', N'M')
INSERT [dbo].[SchoolsKaohsiung] ([Grade], [IDNo], [FullName], [Gender]) VALUES (5, N'E0000000005', N'史欣中', N'M')
INSERT [dbo].[SchoolsKaohsiung] ([Grade], [IDNo], [FullName], [Gender]) VALUES (6, N'E0000000006', N'李妍菱', N'F')
INSERT [dbo].[SchoolsKaohsiung] ([Grade], [IDNo], [FullName], [Gender]) VALUES (6, N'E0000000007', N'王惠娟', N'F')
INSERT [dbo].[SchoolsKaohsiung] ([Grade], [IDNo], [FullName], [Gender]) VALUES (6, N'E0000000008', N'廖秉勳', N'M')
GO
INSERT [dbo].[SchoolsTaichung] ([GradeYear], [StudIDNo], [StudName], [StudGender]) VALUES (1, N'B000000001', N'孫函友', N'M')
INSERT [dbo].[SchoolsTaichung] ([GradeYear], [StudIDNo], [StudName], [StudGender]) VALUES (2, N'B000000002', N'王思全', N'M')
INSERT [dbo].[SchoolsTaichung] ([GradeYear], [StudIDNo], [StudName], [StudGender]) VALUES (2, N'B000000003', N'陳佳玲', N'F')
INSERT [dbo].[SchoolsTaichung] ([GradeYear], [StudIDNo], [StudName], [StudGender]) VALUES (3, N'B000000004', N'謝莉婷', N'F')
INSERT [dbo].[SchoolsTaichung] ([GradeYear], [StudIDNo], [StudName], [StudGender]) VALUES (4, N'B000000005', N'張凱雨', N'M')
INSERT [dbo].[SchoolsTaichung] ([GradeYear], [StudIDNo], [StudName], [StudGender]) VALUES (5, N'B000000006', N'吳怡臻', N'F')
INSERT [dbo].[SchoolsTaichung] ([GradeYear], [StudIDNo], [StudName], [StudGender]) VALUES (6, N'B000000007', N'王吟琳', N'F')
INSERT [dbo].[SchoolsTaichung] ([GradeYear], [StudIDNo], [StudName], [StudGender]) VALUES (6, N'B000000008', N'周德丹', N'M')
GO
INSERT [dbo].[SchoolsTaipei] ([GradeNo], [StudentID], [StudentName], [GenderCode]) VALUES (1, N'A000000001', N'陳至瑄', N'F')
INSERT [dbo].[SchoolsTaipei] ([GradeNo], [StudentID], [StudentName], [GenderCode]) VALUES (1, N'A000000002', N'王婉君', N'F')
INSERT [dbo].[SchoolsTaipei] ([GradeNo], [StudentID], [StudentName], [GenderCode]) VALUES (2, N'A000000003', N'蔡碧松', N'M')
INSERT [dbo].[SchoolsTaipei] ([GradeNo], [StudentID], [StudentName], [GenderCode]) VALUES (3, N'A000000004', N'郭均中', N'M')
INSERT [dbo].[SchoolsTaipei] ([GradeNo], [StudentID], [StudentName], [GenderCode]) VALUES (4, N'A000000005', N'王芷玫', N'F')
INSERT [dbo].[SchoolsTaipei] ([GradeNo], [StudentID], [StudentName], [GenderCode]) VALUES (5, N'A000000006', N'蔡佳謙', N'M')
INSERT [dbo].[SchoolsTaipei] ([GradeNo], [StudentID], [StudentName], [GenderCode]) VALUES (6, N'A000000007', N'李竣傑', N'M')
INSERT [dbo].[SchoolsTaipei] ([GradeNo], [StudentID], [StudentName], [GenderCode]) VALUES (6, N'A000000008', N'陳宏谷', N'M')
GO
INSERT [dbo].[StandardPrice] ([ProductNo], [StandardPrice], [Remark]) VALUES (N'D01', 60, N'')
INSERT [dbo].[StandardPrice] ([ProductNo], [StandardPrice], [Remark]) VALUES (N'D02', 80, N'')
INSERT [dbo].[StandardPrice] ([ProductNo], [StandardPrice], [Remark]) VALUES (N'D03', 100, N'')
INSERT [dbo].[StandardPrice] ([ProductNo], [StandardPrice], [Remark]) VALUES (N'D04', 40, N'')
INSERT [dbo].[StandardPrice] ([ProductNo], [StandardPrice], [Remark]) VALUES (N'D05', 60, N'')
INSERT [dbo].[StandardPrice] ([ProductNo], [StandardPrice], [Remark]) VALUES (N'D06', 300, N'')
INSERT [dbo].[StandardPrice] ([ProductNo], [StandardPrice], [Remark]) VALUES (N'D07', 80, N'')
INSERT [dbo].[StandardPrice] ([ProductNo], [StandardPrice], [Remark]) VALUES (N'D08', 200, N'')
INSERT [dbo].[StandardPrice] ([ProductNo], [StandardPrice], [Remark]) VALUES (N'D09', 100, N'')
INSERT [dbo].[StandardPrice] ([ProductNo], [StandardPrice], [Remark]) VALUES (N'D10', 120, N'')
GO
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'BAG', N'袋', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'BOX', N'盒', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'CASE', N'箱', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'D', N'日', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'G', N'公克', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'H', N'時', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'KG', N'公斤', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'M', N'月', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'PCS', N'個', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'PR', N'張', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'SET', N'組', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'ST', N'件', N'')
INSERT [dbo].[Units] ([UnitNo], [UnitName], [Remark]) VALUES (N'Y', N'年', N'')
GO
INSERT [dbo].[Users] ([IsEnabled], [UserCode], [UserNo], [UserName], [UserPassword], [UserEmail], [Remark]) VALUES (1, N'User', N'U01', N'林宗亦', N'U01', N'', N'')
INSERT [dbo].[Users] ([IsEnabled], [UserCode], [UserNo], [UserName], [UserPassword], [UserEmail], [Remark]) VALUES (1, N'User', N'U02', N'陳雅玲', N'U02', N'', N'')
INSERT [dbo].[Users] ([IsEnabled], [UserCode], [UserNo], [UserName], [UserPassword], [UserEmail], [Remark]) VALUES (1, N'User', N'U03', N'王淑慧', N'U03', N'', N'')
INSERT [dbo].[Users] ([IsEnabled], [UserCode], [UserNo], [UserName], [UserPassword], [UserEmail], [Remark]) VALUES (1, N'User', N'U04', N'陳雅皓', N'U04', N'', N'')
INSERT [dbo].[Users] ([IsEnabled], [UserCode], [UserNo], [UserName], [UserPassword], [UserEmail], [Remark]) VALUES (1, N'User', N'U05', N'楊靜如', N'U05', N'', N'')
INSERT [dbo].[Users] ([IsEnabled], [UserCode], [UserNo], [UserName], [UserPassword], [UserEmail], [Remark]) VALUES (1, N'User', N'U06', N'陳宛雲', N'U06', N'', N'')
INSERT [dbo].[Users] ([IsEnabled], [UserCode], [UserNo], [UserName], [UserPassword], [UserEmail], [Remark]) VALUES (1, N'User', N'U07', N'洪淑玲', N'U07', N'', N'')
INSERT [dbo].[Users] ([IsEnabled], [UserCode], [UserNo], [UserName], [UserPassword], [UserEmail], [Remark]) VALUES (1, N'User', N'U08', N'陳雅婷', N'U08', N'', N'')
INSERT [dbo].[Users] ([IsEnabled], [UserCode], [UserNo], [UserName], [UserPassword], [UserEmail], [Remark]) VALUES (1, N'User', N'U09', N'謝珍瑜', N'U09', N'', N'')
INSERT [dbo].[Users] ([IsEnabled], [UserCode], [UserNo], [UserName], [UserPassword], [UserEmail], [Remark]) VALUES (1, N'User', N'U10', N'張吉丹', N'U10', N'', N'')
INSERT [dbo].[Users] ([IsEnabled], [UserCode], [UserNo], [UserName], [UserPassword], [UserEmail], [Remark]) VALUES (1, N'Admin', N'admin', N'管理者', N'admin', N'admin@gmail.com', N'')
GO
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'AN', N'AN001', N'清華科技', N'清華科技檢驗股份有限公司', N'03-5545022', N'03-5545028', N'新竹縣竹北市中和街55號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'MA', N'AN002', N'保豐堂', N'保豐堂藥品儀器有限公司', N'02-23831569 ', N'02-23141801', N'台北市中正區博愛路14號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EQ', N'AN003', N'謙德', N'謙德技術開發股份有限公司', N'02-26430126', N'02-26430099', N'台北縣汐止市大同路一段263號9樓', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'AN', N'AN004', N'立信', N'立信化學有限公司', N'03-5578787', N'03-5578921', N'新竹市育英里林森路282號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'AN', N'AN005', N'祐大', N'祐大技術顧問股份有限公司', N'03-4930034', N'03-4911143', N'中壢市中央西路二段168號2樓', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'AN', N'AN006', N'台灣檢驗', N'台灣檢驗科技股份有限公司', N'02-22993939', N'02-22981343', N'台北縣五股鄉五工路136號之1', N'(SGS)')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'MA', N'AN007', N'台美', N'金台美有限公司', N'02-22981887', N'02-22902510', N'新北市新莊區五股工業區五工五路21號(100年1/3起)', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'AN', N'AN008', N'中冠資訊', N'中冠資訊股份有限公司', N'07-535-0101', N'07-535-2525', N'高雄市民權二路6號11樓', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EQ', N'AN009', N'德記儀器', N'德記儀器有限公司', N'02-2684-1142', N'02-81926555', N'台北縣樹林市俊英街172巷12號1樓', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'AN', N'AN010', N'松喬環保', N'松喬環保科技股份有限公司', N'02-22983206', N'02-22983314', N'台北縣五股工業區五工二路127號1樓', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'AN', N'AN011', N'兆鼎檢驗', N'兆鼎檢驗科技有限公司', N'02-25236153', N'02-25602885', N'台北市林森北路107巷54號2樓(出報告)', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'AN', N'AN012', N'東量', N'東量科技股份有限公司', N'04-24910688', N'04-24938488', N'台中縣大里市仁美路137巷26號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN001', N'勇源', N'勇源吊車工程行', N'03-5560676-7', N'03-5562591', N'新竹縣竹北市鳳岡路二段175之1號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'MA', N'EN002', N'永竑', N'永竑工程有限公司', N'03-5621380', N'03-5621386', N'新竹市振興里振興路103號2樓', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'MA', N'EN003', N'月星', N'月星起重工程有限公司', N'06-5995437', N'06-5990532', N'台南縣新竹鄉新市村復興路27號1', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'WT', N'EN004', N'冠祥', N'冠祥工程行', N'03-4588786', N'03-4598587', N'平鎮市新貴里中豐路655巷10號1F', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN005', N'西河起重', N'西河起重機械有限公司', N'03-4561775', N'03-4653496', N'桃園縣中壢市仁美里中山東路3段45號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN006', N'榮翔', N'榮翔機械工程有限公司', N'03-4730018', N'03-4732508', N'桃園縣觀音鄉武威村5鄰17號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EQ', N'EN007', N'慶承', N'慶承工程行', N'03-4683556', N'03-4282326', N'平鎮市關東爺路59巷23號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'MA', N'EN008', N'詮宏', N'詮宏空調系統服務股份有限公司', N'03-4641170', N'03-4643653', N'臺北市士林區文林路338號6樓之1', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'FI', N'EN009', N'伯丞', N'伯丞工程有限公司', N'03-5121166', N'', N'新竹縣芎林鄉新鳳村文衡路457號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'PR', N'EN010', N'日月星', N'日月星起重機械工程有限公司', N'07-2239191', N'', N'高雄市三民區凱旋一路212號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN011', N'立群', N'立群企業社', N'4502989', N'', N'桃園縣平鎮市平東路平東路239巷', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'FI', N'EN012', N'山通', N'山通工程有限公司', N'27663625', N'', N'台北市信義區忠孝路4段553巷22弄39號1樓', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN013', N'臺翔', N'臺翔交通有限公司', N'4777452', N'', N'平鎮市中豐路南勢一段93號2F', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN014', N'中明', N'中明汽車貨運有限公司', N'03-4921145', N'03-4921177', N'桃園縣中壢市五權里民族路2段180號', N'(中壢通德)')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'RE', N'EN015', N'鼎誠', N'鼎誠工程行', N'02-82217155', N'02-82217166', N'台北縣中和市華福街57巷14號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN016', N'大象起重', N'大象起重工程', N'06-5996998', N'06-5996958', N'台南縣新市鄉三舍村159之40號', N'(太豪實業有限公司)')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN017', N'鼎機', N'鼎機股份有限公司', N'03-3682323', N'03-3680977', N'台北市士林區社中街406號1樓', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'FI', N'EN018', N'奎陽', N'奎陽科技有限公司', N'02)86776223 ', N'02-86776365', N'鶯歌鎮二橋里中正路156巷33弄22號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'FI', N'EN019', N'嘉翔', N'嘉翔交通股份有限公司', N'03-4909772', N'03-4900922', N'頭洲村民族路6段675巷36號2F ', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'HD', N'EN020', N'昱山', N'昱山飲水機企業有限公司', N'07-3115010', N'07-3115560', N'高雄市三民區十全一路28號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'OT', N'EN021', N'加吉', N'加吉實業有限公司', N'02-29350656', N'02-29343481', N'雲林縣崙背鄉枋南村新庄路47號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EQ', N'EN022', N'錸新', N'錸新工程有限公司', N'037-688185', N'037-687390', N'苗栗縣頭份鎮東庄里7鄰八德一路68巷39號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'RE', N'EN023', N'長虹', N'長虹空調股份有限公司', N'03-4776696', N'03-4770787', N'新屋鄉東明村中正西路1段548號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'OT', N'EN025', N'昇峰', N'昇峰起重工程行', N'037-689498', N'037-666471', N'苗栗縣頭份鎮尖山里文英街87巷27號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'OU', N'EN026', N'奇欣', N'奇欣起重企業社', N'02-29969266', N'', N'台北縣新莊市思源路419巷21號2樓', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN027', N'謝耀慶', N'謝耀慶 (榮研水電工程有限公司)', N'3626271', N'', N'桃園縣八德市廣興里建國路582巷9號1樓', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'OU', N'EN028', N'阡宸工程', N'阡宸工程有限公司', N'', N'', N'桃園縣桃園市中泰里國際路1段1179號9樓之2', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN029', N'大同奧的斯', N'大同奧的斯電梯(股)公司', N'03-3765300', N'03-3633837', N'桃園縣桃園市大林路27號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN030', N'泰順傑', N'泰順傑企業有限公司', N'07-3614705', N'07-3636660', N'高雄市楠梓區後勁東路63號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN031', N'明陽機電', N'明陽機電股份有限公司', N'02-66169288', N'02-26941728', N'台北縣汐止市南陽街54號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'HD', N'EN032', N'恆馳', N'恆馳國際股份有限公司', N'03-3227966', N'03-3228624', N'桃園縣蘆竹鄉五福村南山路一段90巷1之1號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'EN', N'EN033', N'巨漢', N'巨漢工程股份有限公司', N'03-5326677', N'03-5324151', N'新竹市中華路一段324號', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'FI', N'EN034', N'阡宸', N'阡宸工程有限公司', N'03-4730008', N'03-4732508', N'桃園縣觀音鄉武威村5鄰17號', N'(鋐勝)')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'OU', N'EN035', N'一心清潔', N'一心清潔服務有限公司', N'03-5678220', N'03-5297313', N'新竹市仙宮里寶山路452巷19弄3號2F', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'HD', N'EN036', N'太興', N'太興起重工程行', N'03-3862999', N'03-3863666', N'桃園縣大園村中正東路21號1F', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'FI', N'EN037', N'懌龍企業', N'懌龍企業有限公司', N'03-4520128', N'03-4527899', N'中壢市普義里四維路56號1F', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'RE', N'EN038', N'超詮科技', N'超詮科技股有限公司', N'037-672881-2', N'037-672895', N'苗栗縣頭份鎮忠孝里建國路101號2F之一', N'')
INSERT [dbo].[Vendors] ([IsEnabled], [TypeNo], [VendorNo], [ShortName], [VendorName], [CompanyTelphone], [CompanyFax], [CompanyAddress], [Remark]) VALUES (1, N'WT', N'EN039', N'家榮', N'家榮工業有限公司', N'03-4265588', N'03-4255853', N'中壢市忠福路里南園路二路101巷6弄17號1F', N'')
GO
INSERT [dbo].[VendorType] ([TypeNo], [TypeName], [Remark]) VALUES (N'AN', N'檢驗供應商', N'')
INSERT [dbo].[VendorType] ([TypeNo], [TypeName], [Remark]) VALUES (N'EN', N'工程承包商', N'')
INSERT [dbo].[VendorType] ([TypeNo], [TypeName], [Remark]) VALUES (N'EQ', N'設備供應商', N'')
INSERT [dbo].[VendorType] ([TypeNo], [TypeName], [Remark]) VALUES (N'FI', N'濾材供應商', N'')
INSERT [dbo].[VendorType] ([TypeNo], [TypeName], [Remark]) VALUES (N'HD', N'五金供應商', N'')
INSERT [dbo].[VendorType] ([TypeNo], [TypeName], [Remark]) VALUES (N'MA', N'材料供應商', N'')
INSERT [dbo].[VendorType] ([TypeNo], [TypeName], [Remark]) VALUES (N'OT', N'文具用品商', N'')
INSERT [dbo].[VendorType] ([TypeNo], [TypeName], [Remark]) VALUES (N'OU', N'外包承包商', N'')
INSERT [dbo].[VendorType] ([TypeNo], [TypeName], [Remark]) VALUES (N'PR', N'廣告印刷商', N'')
INSERT [dbo].[VendorType] ([TypeNo], [TypeName], [Remark]) VALUES (N'RE', N'電子維修商', N'')
INSERT [dbo].[VendorType] ([TypeNo], [TypeName], [Remark]) VALUES (N'WT', N'原料供應商', N'')
GO
INSERT [dbo].[Purchases] ([SheetNo], [SheetDate], [UserNo], [VendorNo], [TaxCode], [Amounts], [Taxs], [Totals], [Remark]) VALUES (N'20220101001', CAST(N'2022-01-01' AS Date), N'U01', N'AN001', N'O', 1000, 50, 1050, N'')
INSERT [dbo].[Purchases] ([SheetNo], [SheetDate], [UserNo], [VendorNo], [TaxCode], [Amounts], [Taxs], [Totals], [Remark]) VALUES (N'20220101002', CAST(N'2022-01-02' AS Date), N'U02', N'AN002', N'O', 2000, 100, 1100, N'')
GO
INSERT [dbo].[PurchasesDetail] ([ParentId], [ProductNo], [Qty], [Price], [Amount], [DeliveryDate], [Remark]) VALUES (1, N'D01', CAST(5.0000 AS Decimal(18, 4)), CAST(80 AS Decimal(18, 0)), CAST(400 AS Decimal(18, 0)), CAST(N'2022-01-01' AS Date), N'')
INSERT [dbo].[PurchasesDetail] ([ParentId], [ProductNo], [Qty], [Price], [Amount], [DeliveryDate], [Remark]) VALUES (1, N'D02', CAST(6.0000 AS Decimal(18, 4)), CAST(100 AS Decimal(18, 0)), CAST(600 AS Decimal(18, 0)), CAST(N'2022-01-01' AS Date), N'')
INSERT [dbo].[PurchasesDetail] ([ParentId], [ProductNo], [Qty], [Price], [Amount], [DeliveryDate], [Remark]) VALUES (2, N'D01', CAST(10.0000 AS Decimal(18, 4)), CAST(80 AS Decimal(18, 0)), CAST(800 AS Decimal(18, 0)), CAST(N'2022-01-01' AS Date), N'')
INSERT [dbo].[PurchasesDetail] ([ParentId], [ProductNo], [Qty], [Price], [Amount], [DeliveryDate], [Remark]) VALUES (2, N'D02', CAST(12.0000 AS Decimal(18, 4)), CAST(100 AS Decimal(18, 0)), CAST(1200 AS Decimal(18, 0)), CAST(N'2022-01-01' AS Date), N'')
GO
INSERT [dbo].[Subjects] ([SubjectNo], [SubjectName], [Remark]) VALUES (N'C', N'客供品', N'')
INSERT [dbo].[Subjects] ([SubjectNo], [SubjectName], [Remark]) VALUES (N'M', N'原材料', N'')
INSERT [dbo].[Subjects] ([SubjectNo], [SubjectName], [Remark]) VALUES (N'P', N'商品', N'')
INSERT [dbo].[Subjects] ([SubjectNo], [SubjectName], [Remark]) VALUES (N'S', N'半成品', N'')
GO
INSERT [dbo].[Warehouses] ([WarehouseNo], [WarehouseName], [Remark]) VALUES (N'A', N'台北倉庫', N'')
INSERT [dbo].[Warehouses] ([WarehouseNo], [WarehouseName], [Remark]) VALUES (N'B', N'台中倉庫', N'')
INSERT [dbo].[Warehouses] ([WarehouseNo], [WarehouseName], [Remark]) VALUES (N'C', N'高雄倉庫', N'')
GO
INSERT [dbo].[InventorysType] ([TypeNo], [TypeName], [Remark]) VALUES (N'I01', N'一般入庫單', N'')
INSERT [dbo].[InventorysType] ([TypeNo], [TypeName], [Remark]) VALUES (N'I02', N'採購入庫單', N'')
INSERT [dbo].[InventorysType] ([TypeNo], [TypeName], [Remark]) VALUES (N'I03', N'生產入庫單', N'')
INSERT [dbo].[InventorysType] ([TypeNo], [TypeName], [Remark]) VALUES (N'I04', N'研發入庫單', N'')
INSERT [dbo].[InventorysType] ([TypeNo], [TypeName], [Remark]) VALUES (N'I05', N'庫存調整單', N'')
INSERT [dbo].[InventorysType] ([TypeNo], [TypeName], [Remark]) VALUES (N'O01', N'一般領用單', N'')
INSERT [dbo].[InventorysType] ([TypeNo], [TypeName], [Remark]) VALUES (N'O02', N'生產領用單', N'')
INSERT [dbo].[InventorysType] ([TypeNo], [TypeName], [Remark]) VALUES (N'O03', N'研發領用單', N'')
INSERT [dbo].[InventorysType] ([TypeNo], [TypeName], [Remark]) VALUES (N'O04', N'庫存報廢單', N'')
GO
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期中考', N'S001', 88, 90, 79, N'')
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期中考', N'S002', 35, 43, 34, N'')
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期中考', N'S003', 39, 81, 91, N'')
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期中考', N'S004', 90, 77, 32, N'')
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期中考', N'S005', 63, 62, 86, N'')
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期中考', N'S006', 28, 37, 93, N'')
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期末考', N'S001', 34, 45, 47, N'')
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期末考', N'S002', 72, 37, 35, N'')
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期末考', N'S003', 82, 87, 54, N'')
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期末考', N'S004', 62, 34, 45, N'')
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期末考', N'S005', 64, 37, 34, N'')
INSERT [dbo].[Scores] ([ExamName], [StudentNo], [EnglishScore], [ChineseScore], [MathScore], [Remark]) VALUES (N'期末考', N'S006', 82, 73, 68, N'')
GO
INSERT [dbo].[Students] ([StudentNo], [StudentName], [Password], [TeacherNo], [IdentityNo], [Birthday], [ContactEmail], [BlogUrl], [Scores], [Ranks]) VALUES (N'S001', N'王大明', N'001', N'T001', N'H100000001', CAST(N'2010-01-01' AS Date), N's001@gmail.com', N'S001Blog', 77, 0)
INSERT [dbo].[Students] ([StudentNo], [StudentName], [Password], [TeacherNo], [IdentityNo], [Birthday], [ContactEmail], [BlogUrl], [Scores], [Ranks]) VALUES (N'S002', N'李小華', N'002', N'T001', N'H100000002', CAST(N'2008-01-02' AS Date), N's002@gmail.com', N'S002Blog', 45, 0)
INSERT [dbo].[Students] ([StudentNo], [StudentName], [Password], [TeacherNo], [IdentityNo], [Birthday], [ContactEmail], [BlogUrl], [Scores], [Ranks]) VALUES (N'S003', N'楊小明', N'003', N'T001', N'H100000003', CAST(N'2009-12-02' AS Date), N's003@gmail.com', N'S003Blog', 26, 0)
INSERT [dbo].[Students] ([StudentNo], [StudentName], [Password], [TeacherNo], [IdentityNo], [Birthday], [ContactEmail], [BlogUrl], [Scores], [Ranks]) VALUES (N'S004', N'胡小月', N'004', N'T001', N'H100000004', CAST(N'2008-10-22' AS Date), N's004@gmail.com', N'S004Blog', 48, 0)
INSERT [dbo].[Students] ([StudentNo], [StudentName], [Password], [TeacherNo], [IdentityNo], [Birthday], [ContactEmail], [BlogUrl], [Scores], [Ranks]) VALUES (N'S005', N'陳小光', N'005', N'T002', N'H100000005', CAST(N'2007-03-02' AS Date), N's005@gmail.com', N'S005Blog', 92, 0)
INSERT [dbo].[Students] ([StudentNo], [StudentName], [Password], [TeacherNo], [IdentityNo], [Birthday], [ContactEmail], [BlogUrl], [Scores], [Ranks]) VALUES (N'S006', N'林小鳳', N'006', N'T002', N'H100000006', CAST(N'2005-04-02' AS Date), N's006@gmail.com', N'S006Blog', 88, 0)
GO
INSERT [dbo].[Teachers] ([TeacherNo], [TeacherName]) VALUES (N'T001', N'姜松明')
INSERT [dbo].[Teachers] ([TeacherNo], [TeacherName]) VALUES (N'T002', N'鄭偉國')
GO 
4.2 資料庫預覽
當資料成功填入後，你的資料庫關聯圖將呈現如下結構，包含員工、部門、產品與訂單等核心商務資訊：
透過下表，你可以更清楚兩者在建置過程中的不同定位：
| 維度 | 資料表結構 (Schema) | 測試資料 (Initial Data) |
|---|---|---|
| 角色比喻 | 資料的「骨幹」與遊戲規則 | 模擬情境的「靈魂」與玩家 |
| 核心功能 | 定義商務邏輯與資料格式的界限 | 驗證 SQL 指令與程式邏輯的意義 |
| 重要性 | 維護資料完整性與預防錯誤輸入 | 實踐開發環境同步部署的環境模擬 |
5. 建置完成
