Browse by Tags

All Tags » Database (RSS)

Inserting 40,000 records in MYSQL from Asp.Net by vik20000in

Recently I got a task of importing about 40,000 records for a fixed length delimited file to MY SQL database. Copying the data into a list of Business object was not a problem, but to insert about 40000 records in MYSQL in an asp.net application looked...
Filed under: , , ,

Number of Rows Affected Rowcount and Top keyword by vik20000in

Hi, Many a times in a query we need to limit down the number of records returned in the query. This can be done in two ways using the TOP keyword or the row count keyword. Select top 10 from Table This will return the top 10 records from the query. We...
Filed under: ,
More Posts