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] …show more content… Coast Highway','Encinitas','CA','760','555-0108','Current','2003-Jul-25', '18,500','M','25','006') insert into Employee values ('007','Sharp','Nancy','10793 Montecino Road','Ramona','CA','858','555-0135','Current','2003-Jul-12', '2,000','F','24','007') Insert Data/Employee Table Insert Data /Job Title Table insert into JobTitle values (001,'Cashier','Operates cash register to itemize and total Show More
