Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning Microsoft SQL Server 2008 Programming ISBN: 978-0-470-25701-2 Discuss the book Beginning Microsoft SQL Server 2008 Programming, Robert Vieira, ISBN: 978-0-470-25701-2
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Microsoft SQL Server 2008 Programming ISBN: 978-0-470-25701-2 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old March 23rd, 2012, 12:23 AM
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can't find BuildAndPopulateEmployee2.sql

The book says this file is in the downloads but I downloaded the files and can't find it anywhere.

Can someone direct to where to find it...?

Thanks!

J--
Reply With Quote
  #2 (permalink)  
Old July 28th, 2012, 06:13 PM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2012
Posts: 1
Thanks: 0
Thanked 2 Times in 1 Post
Default

you need to download source codes and execute them for each chapter
this one will create new table HumanResources.Employee2
make sure you work with in Advenute work

paste this code in your SQL Query and execute
Start From HERE:

USE AdventureWorks
GO

CREATE TABLE HumanResources.Employee2
(
EmployeeID int NOT NULL,
ManagerID int NULL REFERENCES HumanResources.Employee2(EmployeeID),
JobTitle nvarchar(50) NOT NULL,
LastName nvarchar(50) NOT NULL,
FirstName nvarchar(50) NOT NULL,
CONSTRAINT PK_Employee2_EmployeeID PRIMARY KEY CLUSTERED (EmployeeID ASC)
);

INSERT INTO HumanResources.Employee2(EmployeeID,ManagerID,JobT itle,LastName,FirstName)
VALUES
(1, NULL, 'CEO','Smith', 'Hunter'),
(2, 1, 'CFO', 'Jones', 'Drew'),
(3, 1, 'COO','Lenzy','Sheila'),
(4, 1, 'CTO', 'Huntington', 'Karla'),
(5, 4, 'VP of Engineering', 'Gutierrez', 'Ron'),
(8, 5, 'VP of Engineering', 'Gutierrez', 'Ron'),
(9, 5, 'Software Engineer', 'Bray', 'Marky'),
(10 ,5, 'Data Architect', 'Cheechov', 'Robert'),
(11 ,5, 'Software Engineer', 'Gale', 'Sue'),
(6, 4, 'VP of Professional Services', 'Cross', 'Gary'),
(7, 4, 'VP of Security','Lebowski','Jeff');
Reply With Quote
The Following 2 Users Say Thank You to Avtor For This Useful Post:
milad0101 (November 6th, 2012)
  #3 (permalink)  
Old August 4th, 2014, 12:19 PM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2014
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Lightbulb Unable to get source code

Hi Beautiful

In chapter 3 the book requires you to download BuildAndPopulateEmployee2.sql but I cant find it please help! what can I do???
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't find my SQL Express snorberg BOOK: Professional ASP.NET MVC 2 1 September 15th, 2010 10:58 AM
Where to find Time Tracker database - SQL junkerp BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 1 May 9th, 2009 08:29 AM
Can't find SQL Management Studio exe anywhere? Snakum ASP.NET 2.0 Basics 2 August 7th, 2007 10:07 AM
use SQL to find a record linmu VB.NET 2002/2003 Basics 4 May 6th, 2005 06:03 PM
sql command to find duplicate records? qwjunk Classic ASP Databases 1 January 31st, 2004 03:32 PM



All times are GMT -4. The time now is 03:24 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.