Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-19 : 18:53:25
|
SteveL writes "Here is something I am having some issues with: How do you, in SQL server 7.0, select a random sampling of records from a table, and then export those records to a text file?? Is it possible to do this within SQL server itself, as a stored procedure? Currently I am implementing this through ASP using ADO, and it works... however the consequences are disastrous. When the webserver opens the SQL table, and then starts writing records out to the file system object, it literally locks the session (and any other users attempting to create new sessions) until it is complete. This, of course, is unacceptable and I'm sure there is a much better way to do this. I was thinking that if the SQL server was running the procedure internally it would free the websessions and performance would improve dramatically. Any ideas????"
|
|
|
|
|
|
Exporting a random set of records to a text file