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: sql, ADO .NET

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: sql, database, website