Wrox Programmer Forums
|
BOOK: Beginning SQL Server 2005 Programming ISBN: 978-0-7645-8433-6
This is the forum to discuss the Wrox book Beginning SQL Server 2005 Programming by Robert Vieira; ISBN: 9780764584336
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning SQL Server 2005 Programming ISBN: 978-0-7645-8433-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 21st, 2007, 07:48 PM
Registered User
 
Join Date: Jul 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter10code.sql does not execute?

Below is the error message I recieve when trying to run the code from the Chapter10code.sql?
What do I need to do to run this code?



Msg 321, Level 15, State 1, Procedure CustomerPhoneList_vw, Line 5
"s" is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode is set to 90.
Msg 154, Level 15, State 1, Procedure CustomerPhoneList_vw, Line 11
a USE database statement is not allowed in a procedure, function or trigger.
Msg 156, Level 15, State 1, Procedure Employees_vw, Line 13
Incorrect syntax near the keyword 'SELECT'.
Msg 111, Level 15, State 1, Procedure Employees_vw, Line 15
'CREATE VIEW' must be the first statement in a query batch.
Msg 102, Level 15, State 1, Procedure Employees_vw, Line 32
Incorrect syntax near 'FirstName'.
Msg 154, Level 15, State 1, Procedure Employees_vw, Line 39
a USE database statement is not allowed in a procedure, function or trigger.
Msg 156, Level 15, State 1, Procedure CustomerOrders_vw, Line 19
Incorrect syntax near the keyword 'SELECT'.
Msg 154, Level 15, State 1, Procedure CustomerOrders_vw, Line 25
a USE database statement is not allowed in a procedure, function or trigger.
Msg 156, Level 15, State 1, Procedure YesterdaysOrders_vw, Line 21
Incorrect syntax near the keyword 'USE'.
Msg 154, Level 15, State 1, Procedure YesterdaysOrders_vw, Line 21
a USE database statement is not allowed in a procedure, function or trigger.
Msg 111, Level 15, State 1, Procedure YesterdaysOrders_vw, Line 39
'CREATE VIEW' must be the first statement in a query batch.
Msg 102, Level 15, State 1, Procedure YesterdaysOrders_vw, Line 48
Incorrect syntax near 'WITH'.
Msg 102, Level 15, State 1, Procedure YesterdaysOrders_vw, Line 57
Incorrect syntax near '1'.
Msg 111, Level 15, State 1, Procedure YesterdaysOrders_vw, Line 75
'ALTER VIEW' must be the first statement in a query batch.
Msg 319, Level 15, State 1, Procedure YesterdaysOrders_vw, Line 76
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Msg 111, Level 15, State 1, Procedure YesterdaysOrders_vw, Line 100
'ALTER VIEW' must be the first statement in a query batch.
Msg 319, Level 15, State 1, Procedure YesterdaysOrders_vw, Line 101
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Msg 154, Level 15, State 1, Procedure YesterdaysOrders_vw, Line 122
a USE database statement is not allowed in a procedure, function or trigger.
Msg 207, Level 16, State 1, Procedure CustomerOrders_vw, Line 13
Invalid column name 'CustomerID'.
Msg 207, Level 16, State 1, Procedure CustomerOrders_vw, Line 13
Invalid column name 'CustomerID'.
Msg 208, Level 16, State 1, Procedure CustomerOrders_vw, Line 13
Invalid object name 'dbo.Order Details'.
Msg 911, Level 16, State 1, Line 5
Could not locate entry in sysdatabases for database 'NorthwindBulk'. No entry found with that name. Make sure that the name is entered correctly.







Similar Threads
Thread Thread Starter Forum Replies Last Post
SQLExpress: 1.about "Execute sql button" 2.about garaxan SQL Language 1 September 3rd, 2007 07:26 AM
execute sql fishypew SQL Server 2000 4 May 18th, 2005 09:00 AM
how can i execute SQL in UDF vinod_mnr SQL Server 2000 1 March 18th, 2005 12:51 PM
sql execute from an include. robprell PHP Databases 1 October 4th, 2004 12:28 PM
how do I execute an SQL update [email protected] VB How-To 1 June 22nd, 2003 06:50 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.