:: CODE Magazine ::

	*Category: VFP and SQL Server*
	6 Articles found and displayed in this view. LINQx Magazine/Issue: CoDe Magazine, 2005 - Nov/Dec Release Date: Friday, October 28, 2005 Quick ID: 0511121 Microsoft demonstrated a new technology at PDC called LINQ (Language Integrated Query). The following note from Alan Griver, a member of the LINQ team at Microsoft, offers some details related to the LINQ project. In future issues of CoDe Magazine we will have more details on LINQ.Microsoft demonstrated a new technology at PDC called LINQ (Language Integrated Query). The following note from Alan Griver, a member of the LINQ team at Microsoft, offers some details related to the LINQ project. In future issues of CoDe Magazine we will have more details on LINQ. Creating User-Defined Data Types in Yukon Magazine/Issue: CoDe Magazine, 2004 - January/February Release Date: Thursday, January 01, 2004 Quick ID: 0303052 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. SQL Server 2000 Replication 101: Terminology, Types, and Configuration Magazine/Issue: CoDe Magazine, 2003 - November/December Release Date: Saturday, November 01, 2003 Quick ID: 0311101 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 terminology surrounding replication, the types of replication available in SQL Server, and how to configure (that is, install) replication. Implementing Two-Way Control Binding for Web Forms Magazine/Issue: CoDe Magazine, 2003 - November/December Release Date: Saturday, November 01, 2003 Quick ID: 0311041 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 source. This article examines what's wrong with simple data binding and provides a set of subclasses, making data binding a lot quicker and requiring much less manual code. Handling SQL Server Errors in Nested Procedures Magazine/Issue: CoDe Magazine, 2003 - May/June Release Date: Thursday, May 01, 2003 Quick ID: 0305111 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. Scripting SQL Server 2000 Indexes Magazine/Issue: CoDe Magazine, 2003 - Jan/Feb Release Date: Wednesday, January 01, 2003 Quick ID: 0301101 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 to remove and add those indexes. In this article you'll learn how to use Transact-SQL stored procedures to generate Transact-SQL indexing scripts that are more robust and less laborious than SQL Server's Enterprise Manager scripting tool.