Pos-410
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 on Helpwriting.net
...
OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] )
ON [PRIMARY] GO CREATE TABLE [dbo].[Employee]( [JobTitleID] [int] NULL,
CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED ( [EmployeeID]
ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO CREATE
TABLE [dbo].[JobTitle]( CONSTRAINT [PK_JobTitle] PRIMARY KEY
CLUSTERED ( [JobTitleID] ASC )WITH (PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] )
ON [PRIMARY] GO insert into Employee values ( 001 , Edelman , Glenn , 175
Bishops Lane , La Jolla , CA , 619 , 555 0199 , Current , 2003 Oct 07 , 21500 , M ,
64 , 001 ) insert into Employee values ( 002 , McMullen , Eric , 763 Church Street ,
Lemongrove , CA , 619 , 555 0135 , Current , 2002 Nov 01 , 13,500 , M , 20 , 002 )
insert into Employee values ( 003 , Slentz , Raj , 123 Torrey Drive , North Clairmont
, CA , 619 , 555 0123 , Current , 2000 Jun 01 , 48,000 , M , 34 , 003 ) insert into
Employee values ( 004 , Broun , Erin , 2045 Parkway Apt 2B , North Clairmont , CA
, 760 , 555 0100 , Current , 2003 Mar 12 ,10,530 , F , 24 , 004 ) insert into Employee
values ( 005 , Carpenter , Donald , 927 Second Street , Encinitas , CA , 619 , 555
0154 , Current , 2003 Nov 01 , 15,000 , M , , 005 )