Pos-410 - Week 2 - Table Queries Sql Server Database - Kudler Fine Foods
Table Queries SQL Server Database - Kudler Fine Foods
Week 2
POS/410\
April, 09 2012
Create Database
USE [master]
GO
/****** Object: Database [Jeff Thompson Sr - POS 410 - IA - KVO] Script Date: 03/27/2012 09:23:56 ******/
CREATE DATABASE [Jeff Thompson Sr - POS 410 - IA - KVO] ON PRIMARY
( NAME = N'Jeff Thompson Sr - POS 410 - IA - KVO', FILENAME = N'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - POS 410 - IA - KVO.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON
( NAME = N'Jeff Thompson Sr - POS 410 - IA - KVO_log', FILENAME = N'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - POS 410 - IA - KVO_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
USE [master]
GO
/****** Object: Database [Jeff Thompson Sr - POS 410 - IA - KVO] Script Date: 03/27/2012 09:23:56 ******/
CREATE DATABASE [Jeff Thompson Sr - POS 410 - IA - KVO] ON PRIMARY
( NAME = N'Jeff Thompson Sr - POS 410 - IA - KVO', FILENAME = N'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - POS 410 - IA - KVO.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON
( NAME = N'Jeff Thompson Sr - POS 410 - IA - KVO_log', FILENAME = N'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - POS 410 - IA - KVO_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
Create Employee Table/Columns
USE [Jeff Thompson Sr - POS 410 - IA - KVO]
GO
/****** Object: Table [dbo].[Employee] Script Date: 03/27/2012 10:39:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Employee]( [EmployeeID] [int] NOT NULL, [LastName] [nvarchar](50) NULL, [FirstName] [nvarchar](50) NULL, [Address] [nvarchar](30) NULL, [City] [nvarchar](30) NULL, [State] [nvarchar](20) NULL, [AreaCode] [nvarchar](20) NULL, [TelephoneNumber] [nvarchar](20) NULL, [EmployerInformationReportClassification] [nvarchar](max) NULL, [HireDate] [date] NULL, [Salary] [money] NULL,
Week 2
POS/410\
April, 09 2012
Create Database
USE [master]
GO
/****** Object: Database [Jeff Thompson Sr - POS 410 - IA - KVO] Script Date: 03/27/2012 09:23:56 ******/
CREATE DATABASE [Jeff Thompson Sr - POS 410 - IA - KVO] ON PRIMARY
( NAME = N'Jeff Thompson Sr - POS 410 - IA - KVO', FILENAME = N'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - POS 410 - IA - KVO.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON
( NAME = N'Jeff Thompson Sr - POS 410 - IA - KVO_log', FILENAME = N'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - POS 410 - IA - KVO_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
USE [master]
GO
/****** Object: Database [Jeff Thompson Sr - POS 410 - IA - KVO] Script Date: 03/27/2012 09:23:56 ******/
CREATE DATABASE [Jeff Thompson Sr - POS 410 - IA - KVO] ON PRIMARY
( NAME = N'Jeff Thompson Sr - POS 410 - IA - KVO', FILENAME = N'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - POS 410 - IA - KVO.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON
( NAME = N'Jeff Thompson Sr - POS 410 - IA - KVO_log', FILENAME = N'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Jeff Thompson Sr - POS 410 - IA - KVO_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
Create Employee Table/Columns
USE [Jeff Thompson Sr - POS 410 - IA - KVO]
GO
/****** Object: Table [dbo].[Employee] Script Date: 03/27/2012 10:39:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Employee]( [EmployeeID] [int] NOT NULL, [LastName] [nvarchar](50) NULL, [FirstName] [nvarchar](50) NULL, [Address] [nvarchar](30) NULL, [City] [nvarchar](30) NULL, [State] [nvarchar](20) NULL, [AreaCode] [nvarchar](20) NULL, [TelephoneNumber] [nvarchar](20) NULL, [EmployerInformationReportClassification] [nvarchar](max) NULL, [HireDate] [date] NULL, [Salary] [money] NULL,