Chapter 1: Datatype-Related Problems, XML, and CLR UDTs In this chapter, I'll cover some T-SQL programming issues related to datatypes, focusing on DATETIME, character manipulations, large objects, and new functionality in Microsoft SQL Server 2005. Chapter 2: Temporary Tables and Table Variables In this chapter, I will try to provide you with a clear picture of how the different temporary object types behave, in which circumstances you should use each, and whether you should use them at all.
|
|
Read more about this free ebooks:Inside Microsoft SQL Server 2005: T-SQL Programming
|
Chapter 1: The Role of T-SQL. This chapter provides a brief history of T-SQL and the ANSI SQL standards. It also provides some basic hints and tips for getting the most out of your T-SQL code and maintaining it over the long term. Chapter 2: Tools of the Trade. SQLCMD and SQL Server Management Studio (SSMS) are new tools designed to replace osql, Enterprise Manager, and Query Analyzer. The online help system and Adventure-Works sample database are also discussed. Chapter 3: T-SQL for SQL Server 2000 Programmers. |
|
Read more about this free ebooks:The Expert's Voice in SQL Server - Pro T-SQL 2005 Programmers Guide
|
Chapter 1: What Is MySQL? - This chapter begins with an overview of the most important concepts from the world of databases and then delves into the possibilities and limitations of MySQL. Chapter 2: The Test Environment - In this chapter we discuss first of all how to set up the test environment for MySQL on a local computer. Chapter 3: Introductory Example - The best way of becoming familiar with a new database or development system is to work through a full-fledged example. Thus in this chapter our goal is to create a web site for the purpose of conducting an opinion poll.
|
|
Read more about this free ebooks:The Definitive Guide to MySQL (2nd Edition)-The Expert's Voice in Open Source
|
Chapter 1 is an introduction to phpMyAdmin, its history, and main features. Chapter 2 provides detailed coverage of the different installation and configuration options, including installing one copy of phpMyAdmin for multiple users, and configuring it to manage many servers. Security issues are also discussed in this chapter. Chapter 3 is an overview of the graphical interface of phpMyAdmin. A more detailed examination of the various panels and windows is provided in the following chapters. In Chapter 4 we see how to create our first database and table and its various fields.
|
|
Read more about this free ebooks:Mastering phpMyAdmin 2.8 for Effective MySQL Management
|
Beginning SQL Server 2008 for Developers is for those who see themselves as becoming developers, database administrators, or a mixture of both but have yet to tread that path with SQL Server 2008. Whether you have no knowledge of databases, have knowledge of desktop databases such as Microsoft Access, or even come from a server-based background such as Oracle, this book will provide you with the insight to get up and running with SQL Server 2008. Right from the start, this book will expand your basic knowledge, and you will soon find yourself moving from a beginner toward a competent and professional developer. |
|
Read more about this free ebooks:Beginning SQL Server 2008 for Developers: From Novice to Professional
|
|
|
<< Start < Prev 1 2 3 4 5 6 Next > End >>
|
|
Page 4 of 6 |