Pos-410 - Week 2 - Table Queries Sql Server Database - Kudler Fine Foods Essay examples

Words: 1563
Pages: 7

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