SQL
Access to SQL Server
Published on 29. January 2002
Book
Paperback/Softback
XIX, 698 pages
978-1-893115-30-9 (ISBN)
Description
This book is peppered with advice and tips from industry experts on everything from basic SQL right up to an introduction on executing Stored Procedures via the Web. The authors see SQL - as it is used in Access, MSDE and SQL Server, as being the common thread.
More details
Edition
First Edition
Language
English
Place of publication
Berkeley
United States
Target group
Professional and scholarly
Professional/practitioner
Product notice
Paperback (trade)
Unsewn / adhesive bound
Illustrations
XIX, 698 p.
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 38 mm
Weight
1327 gr
ISBN-13
978-1-893115-30-9 (9781893115309)
DOI
10.1007/978-1-4302-1573-8
Schweitzer Classification
Persons
Susan Sales Harkins is an independent consultant specializing in Microsoft Access, Office, and Visual Basic for Applications. For several years, Susan was editor-in-chief at The Cobb Group, publishing several computer-based monthly journals. She's the author of two books on Access: Using Microsoft Access 97 and Using Microsoft Access 2000. Currently, Susan writes for a number of publishers, including Element K Journals, PC Magazine, ZDNet, CNet, and TechRepublic.
Content
1: Structured Query Language.- 2: An Introduction to Using Jet SQL in Access.- 3: An Introduction to Relational Database Theory.- 4: SQL Grammar.- 5: Retrieving Data.- 6: Modifying Data.- 7: Grouping and Summarizing Data.- 8: Creating and Modifying Tables.- 9: Manipulating Relationships and Indexes.- 10: Advanced Manipulation Techniques.- 11: Queries: The Sequel.- 12: An Introduction to the SQL Server 2000 Desktop Engine.- 13: Introduction to SQL Server.- 14: SQL Server Views.- 15: SQL Server Structure.- 16: Working with Stored Procedures.- 17: Upsizing Directly from Access.- 18: Security Issues.- 19: SQL Server Meets the Web.- Appendix A: More SQL Solutions to Common Problems.- Problem 1: Begin a Label Report at Any Label on the Sheet.- Problem 2: Finding the Second-Highest or -Lowest Value in a Group.- Problem 3: Adding a Summary Row to a Query.- Problem 4: Returning Alternating Rows.- Problem 5: Producing a Random Sort.- Problem 6: Counting Specific Entries.- Problem 7: Counting Unique Values.- Problem 8: Finding Unique Values.- Problem 9: Displaying Optional Data in a List Control.- Problem 10: Custom Sort for Controls.- Appendix B: An Introduction to Using ADO and ADOX with SQL.- Microsoft ActiveX Data Objects Library (ADO).