preview

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

Better Essays
Open Document

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…

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')

Get Access
Related
Get Access