Monthly Archives: April 2007

TIP: Copying rows from a DataView to a new DataTable

Posted on April 24, 2007 by Jag

In an ASP.NET app, I had a need to copy the data from a DataView to a DataTable for additional manipulation of the rows (without effecting the original table that the DataView was created on). Came across this:   C# … Continue reading →

Posted in VB.NET | Tagged , | Leave a comment

Northwind database scripts for Oracle

Posted on April 12, 2007 by Jag

"Northwind" is a demonstration database provided by Microsoft.  It is generally available with Access or SQL Server 2000.  I generated Oracle script for the same Northwind database (along with INSERT statements), to make it available as a demonstration database for … Continue reading →

Posted in Oracle | Tagged | 100 Comments

Part 3: More about CASE, @@ROWCOUNT and TABLES in T-SQL

Posted on April 2, 2007 by Jag

Hello,   This is third in series focusing on the following topics:   A bit more concentration on CASE CASE with IF Utilizing @@ROWCOUNT Working with TABLES (Table Variables) in T-SQL The article is available at http://www.aspfree.com/c/a/MS-SQL-Server/Using-ROWCOUNT-and-TABLE-Variables-for-Database-Interactions-with-TransactSQL/ thanks Jag

Posted in SQL Server 2005 | Tagged | 44 Comments