Connect and share knowledge within a single location that is structured and easy to search. My problem is that I have to run this stored procedure a lot and therefore I have some performance issues. Is there something I can improve in my implementation to improve performance? Is there another way to write in a file using SQL Server that could be faster? If not, I think I'll have to try to call it less often.
This procedure replaces the one I had written in my question. Finally, i've written a second stored procedure in order to write the lines that are in my table. This stored procedure is executed every 5 minutes by a scheduled task on the server. Whis this solution, I don't have to open and close my file everytime I want to write one line into it.
Since writing is now running on its side, performances have been a lot improved. Sign up to join this community. The best answers are voted up and rise to the top.
Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Stored procedure to write in a file Ask Question. Mob Scene. Sage X3 Pricing Guide. Online Bill Pay. About RKL eSolutions. Why Choose RKL? Meet our Management Team. Inspector Gadget. RKL eSolutions Blogs. By Richard Cushing. Leave a Comment. A stored procedure to write-out the data First, we will need a stored procedure that we can call to write-out to the designated file the data that we will gather and pass to it.
Its sole purpose is to take the text gathered elsewhere and passed to it, and write it to the designated file including the path. Some T-SQL scripting to gather the data to be exported For our example, we have prepared a simple script that 1 writes a header line into the file, and 2 writes a number of rows of data based on in this case vendor payments.
Here's what the resulting file looks like So, when this is executed in our demo database , here is what the resulting file contains: This is a NEW header row for the file; ; How's your SQL? Are there other SQL problems do you need assistance with? You may also like. Read more. Need Support? Get in Touch. Blog Updates. Get blog updates by email. Simply fill in your name and email address and hit subscribe. Looking for something specific? Search the blog:.
Quick Links. Local Offices. Louis Syracuse Tampa Los Angeles. List of Services. This is currently too vague and depends entirely on external resources. All those three links go to the same page for me. It will be. Add a comment. Active Oldest Votes. Try this First of all create the stored procedure rather than alter.
Suvethan Nantha Suvethan Nantha 2, 12 12 silver badges 25 25 bronze badges. I tryed this code and I mentioned about it in the question. This does not writes anything to the file. Thanks — JollyRoger. JollyRoger what do you mean by not writing anything? I have done above changes and saved string to test. I saw your question that it didn't write anything to the file. But I did it with the above code. Unfortunately it writes nothing. JollyRoger did you follow what i told here?
JollyRoger copy the stored procedure and create it if there is no stored procedure with the name — Suvethan Nantha. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.
0コメント