I need to write a stored procedure to output some data to a text file which (hopefully) will not be too much of a problem. The question I have is do you have to use strictly 'C' language code in the procedure or can 'C++' code be used. I have not used either in a number of years, so would only like to concentrate on what is necessary to write the SP. Any info would be greatly appreciated!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Stored Procedure code
- Thread starter ascheper
- Start date
Stored procedures are written in T-SQL not C or C++.
usually I export data using Data Transformation Services (DTS) rather than stored procedures. There is a really easy wizard for this if you want to do a fairly simple export.
To get to it, right click on Data Transformation Services in Enterprise Manager and go to All tasks and select Export Data.
Good luck
usually I export data using Data Transformation Services (DTS) rather than stored procedures. There is a really easy wizard for this if you want to do a fairly simple export.
To get to it, right click on Data Transformation Services in Enterprise Manager and go to All tasks and select Export Data.
Good luck
- Thread starter
- #3
Thank you for the info SQLSister, I've begun reading Advanced Transact-SQL for SQL Server 2000 by Itzik Ben-Gan and Dr. Tom Moreau and may have misunderstood them when saying that "it" was written in 'C'. I was thinking the actual SP's, but they may have meant the program itself...anyway, thank you again...I'll give that a try.
Andrew
Andrew
- Status
Similar threads
- Locked
- Question