AspNetAtoms.com daily updates on ASP.NET Tutorials, Articles, Authors and more. Subscribe to our newsletter and receive updates on ASP.NET resources on the Internet.

Categories

Recent Posts

Working with Computed Columns : Scott Mitchell

Sunday, July 06 2008

When creating a database table, Microsoft SQL Server allows you to define a computed column whose value is calculated from an expression that usually references other values in the same database record. Such values are read-only at the database, which requires special considerations when working with TableAdapters. In this tutorial we learn how to meet the challenges posed by computed columns. Microsoft SQL Server allows for computed columns, which are columns whose values are calculated from an expression that usually references the values from other columns in the same table. As an example, a time tracking data model might have a table named ServiceLog with columns including ServicePerformed, EmployeeID, Rate, and Duration, among others....



Read More:
Working with Computed Columns : Scott Mitchell
Also See:
Caching Techniques in ASP.NET 2.0 : Richard Bean
Inserting, Updating, and Deleting Data with the SqlDataSource : Scott Mitchell
LINQ to SQL Instantiation : Brian Mains
Updating and Deleting Existing Binary Data : Scott Mitchell
How to implement remote debugging in Visual Studio 2005 : Akshay N. S.

Post your comment

Comment