libri scuola books Fumetti ebook dvd top ten sconti 0 Carrello


Torna Indietro

sales harkins susan; reid martin - sql
Zoom

SQL Access to SQL Server

;




Disponibilità: Normalmente disponibile in 15 giorni
A causa di problematiche nell'approvvigionamento legate alla Brexit sono possibili ritardi nelle consegne.


PREZZO
54,98 €
NICEPRICE
52,23 €
SCONTO
5%



Questo prodotto usufruisce delle SPEDIZIONI GRATIS
selezionando l'opzione Corriere Veloce in fase di ordine.


Pagabile anche con Carta della cultura giovani e del merito, Carta della Cultura e Carta del Docente


Facebook Twitter Aggiungi commento


Spese Gratis

Dettagli

Genere:Libro
Lingua: Inglese
Editore:

Apress

Pubblicazione: 01/2002
Edizione: First Edition





Trama

SQL: Access to SQL Server is more than just a comprehensive reference tool for Access developers. You'll also find efficient SQL solutions for common Access problems and tasks, as well as helpful hints and warnings about what to avoid. Learning Jet SQL is an important step from just using Access to developing with Access.

In addition to learning Jet SQL, readers will embark on a journey into the world of SQL Server 2000. The journey starts when you learn how to install SQL Server and ends with an introduction to XML and ASP. Along the way, using Access Data Projects, you'll see features new to SQL Server 2000, including functions that return tables, instead of triggers and gotchas with upsizing. The authors highlight not only the enormous opportunities awaiting you as an Access developer, but also the potential challenges and pitfalls you may face as you move from Access to SQL Server 2000.





Sommario

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




Autore

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.










Altre Informazioni

ISBN:

9781893115309

Condizione: Nuovo
Dimensioni: 235 x 191 mm
Formato: Brossura
Illustration Notes:XIX, 698 p.
Pagine Arabe: 698
Pagine Romane: xix


Dicono di noi