Browse by Tags

SQL Bulk insert and ADO .NET SQLBulkCopy
Tuesday, April 15, 2008 6:39 PM
--SQL Procedure to insert data from a comma delimited text file use MyDatabase --- Create a temp table to hold the data CREATE TABLE TmpStList ( username varchar (100) NOT NULL, userpassword varchar (100) NOT NULL, ) go --bulk insert from a text file BULK INSERT tmpStList FROM 'C:\temp.txt' WITH (FIELDTERMINATOR = ',') go -- insert into a destination... Read More...
by xxxd | with no comments
Filed under: ,
Some Dos and Dont's in designing website databases
Wednesday, January 23, 2008 2:22 AM
1. Choose the right data storage device Do not use XML files as the sole data storage device, for XML files are not ideal for constant data operations (delete, insert, update). Do not use Access database, because a. Access Database is not suitable for multiple concurrent users; b. Access database is not scalable. SQL server is a preferred database choice for... Read More...
by xxxd
Filed under: , ,

This site

This Blog

Syndication

Sponsors

  • MaximumASP
  • Social Bookmarking
    Online Shopping
    asp.net hosting
    UK online local dating