Tuesday, June 29, 2010
Tuesday, June 8, 2010
In this article, I am going to show you how you can create a Data Access Layer (to store, retrieve and manage data in relational database) in ADO .NET. I will show how you can make it data provider independent, so that you don't have to re-write your data access layer if the data storage source changes overtime and also you can reuse it in other applications that you develop. For details, click here.
Friday, June 4, 2010
SQL Server 2008 System Functions to Research Tables, Views, Indexes, Columns, Stored Procedures, etc.
SQL Server provides several system meta data functions to get property values for different object types. Each system meta data function has a set of properties you can query using the system meta data function. In this article, I am going to outline examples on the following functions, for details click here.
- OBJECTPROPERTY and OBJECTPROPERTYEX