Articles filed in category 'VFP and SQL Server'

  • Creating User-Defined Data Types in Yukon
    The next version of SQL Server (code name Yukon) has extensive support of the Common Language Runtime (CLR).Previous versions of SQL Server (2000 and earlier) had a mechanism for creating custom data types. These data types were nothing more than aliases to system data types. In Yukon, you can create your own fully functional custom data types.
  • Handling SQL Server Errors in Nested Procedures
    Basic error handling in SQL Server's programming language, Transact-SQL, is straightforward.But when you nest calls to stored procedures, and the procedures have SQL transactions, error handling becomes much more complex. In this article I'll show you some tried-and-true models for how to handle errors in nested stored procedures with transactions.
  • Implementing Two-Way Control Binding for Web Forms
    ASP.NET has considerably raised the bar for Web development with very rich developer functionality built into a flexible and highly extensible object model.If you have a background of hand-coding ASP or other scripting or CGI-style technology, .NET's redundant code reduction and development process simplification seems almost too good to be true. But data binding for controls leaves a lot to be desired in terms of ease-of-use and reading the data back into the data sourc...See More
  • LINQx
    In this article, Yair Alan Griver introduces Microsoft's LINQ (Language Integrated Query), a framework that integrates querying capabilities directly into C# and Visual Basic, enabling unified data access across objects, databases, and XML. LINQ provides SQL-like query operators for in-memory collections and includes specialized APIs for relational data (DLinq) and XML (XLinq). Griver highlights LINQ's flexibility and ease of use, demonstrated through examples, and point...See More
  • Scripting SQL Server 2000 Indexes
    Adding indexes to tables is the most effective way to optimize your SQL Server query performance. Tables that you query often may require several indexes in order to handle the various search arguments you send. There is one particular situation where indexes on large tables are a hindrance, though. When you're bulk-copying data into the table, it's best to have either no index at all, or just a clustered index. For those situations it is best to use Transact-SQL scripts...See More
  • SQL Server 2000 Replication 101: Terminology, Types, and Configuration
    Replication figures as one of the more prominent features of SQL Server 2000.Replication is a complex application that uses a combination of stored procedures and executables to distribute and copy data between SQL Server databases. If you take care not to get lost in the details and confused by occasionally misleading terms, replication can be an important component in the database architecture of a SQL Server application. In this article, you'll learn about the termino...See More