|
""Database backup""; ""Point-in-time recovery""; ""Triggers""; ""Referential integrity""; ""Indexes""; ""Defaults""; ""Rules""; ""Primary key generation""; ""Stored procedures""; ""Views""; ""User-defined data types""; ""Replication""; ""Transactions""; ""Scalability"" |
""Reliability""""Advantages of client/server""; ""Performance""; ""Cost""; ""Security""; ""Scalability""; ""Summary""; ""Chapter 2 Visual FoxPro for Client/Server Development""; ""Object-oriented programming (OOP)""; ""Support for COM""; ""Built-in client/server support""; ""Built-in local data engine""; ""Support for other data-access technologies""; ""Rapid Application Development (RAD)""; ""Summary""; ""Chapter 3 Introduction to SQL Server 7.0""; ""Why move to SQL Server?""; ""Capacity""; ""Concurrency""; ""Robustness""; ""Security""; ""Installation""; ""SQL Server editions"" |
""Licensing""""Character sets""; ""Sort order""; ""Network libraries""; ""Databases, database files and the transaction log""; ""Types of databases""; ""Database files""; ""Creating a database""; ""The transaction log""; ""How SQL Server allocates storage""; ""Transactions and locking""; ""Implicit and explicit transactions""; ""Locking""; ""Database objects""; ""SQL Server object names""; ""Tables""; ""Enforcing data integrity""; ""Indexes""; ""Views""; ""Stored procedures""; ""Triggers""; ""Summary""; ""Chapter 4 Remote Views""; ""Connections""; ""Remote views""; ""Updatable views"" |
""Buffering""""Committing and refreshing buffers""; ""Other view properties""; ""FetchAsNeeded and FetchSize""; ""MaxRecords""; ""FetchMemo""; ""Tables""; ""Field properties""; ""DefaultValue""; ""RuleExpression""; ""UpdateName""; ""DataType""; ""Summary""; ""Chapter 5 Upsizing: Moving from File-Server to Client/Server""; ""Why upsize?""; ""Using the SQL Server Upsizing Wizard""; ""Indexes""; ""Defaults""; ""Relationships""; ""Validation rules""; ""Changes made locally""; ""Finished at last? Modifying the results of the Upsizing Wizard""; ""The local database""; ""Summary"" |
""Chapter 6 Extending Remote Views with SQL Pass Through""""Connecting to the server""; ""The SQLConnect() function""; ""The SQLStringConnect() function""; ""Handling connection errors""; ""Disconnecting""; ""Accessing metadata""; ""The SQLTables() function""; ""The SQLColumns() function""; ""Submitting queries""; ""Queries that return a result set""; ""Retrieving multiple result sets""; ""Queries that modify data""; ""Parameterized queries""; ""Making SQL pass through result sets updatable""; ""Calling stored procedures""; ""Handling input and output parameters""; ""Transaction management"" |
""Binding connections"" |