I'm getting sql timeout errors with this code, so I'm wondering if someone could help me make it smaller. I was wondering if there was a way to grab the @@Identity while inserting records so I didn't have to do the third statement which searches the key column for a unique id. Here is what I'm...
Hello all. I'm working on a project that is loading fairly large comma/return character seperates .txt files into a database. I know BULK INSERT is the fastest way to do this, however the company that is the web host for this won't allow me to have BULK INSERT permission so when trying it I...
Hello all. I have a client that is signed up through a web service that has their sql database on a seperate computer from where the pages are hosted. We seem to be getting much slower connections than I am used to in SQL and I think the problem might be that we are connecting to SQL through...
Ok, I think I'm really over my head on this one. I've been designing a Flash/PHP/mySQL database driven e-commerce site for the company I work for, however now I'm informed that they want to have this span across multiple servers. I can handle php/mySQL enough to get an e-commerce site up and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.