Hi, We just switched one of our databases from using Rbase to SQL 2000 and considered using stored procedures for processing the new data files. Since the processing programs were already written in Rbase, it was easier to keep the processing the same, then unload the new data to csv files for automatically loading into SQL 2000 using the DTS function. This has worked well and the only data going into SQL 2000 is final data.
Ted -----Original Message----- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 8:29 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: SQL Learning recommendations Thanks. I also wonder about the general question. How often do people use stored procedures with SQL 2000 given that the use Witango? How useful is it to learn the use of XML with SQL 2000 given the use of witango? Dan on 12/11/03 8:18, Jon Pevzner at [EMAIL PROTECTED] wrote: > Dan, > > I have the Guru's Guide to Transact-SQL and it can be cryptic at > times, but nonetheless a good reference book. Professional SQL Server > 2000 Programming by Robert Vieira is also an excellent book... Good > info, covers many areas with relative simplicity and pretty easy to > read. This guy knows his stuff. > > Jon > > -----Original Message----- > From: Dan Stein [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 11, 2003 8:09 AM > To: [EMAIL PROTECTED] > Subject: Witango-Talk: SQL Learning recommendations > > > List, > > I am looking to learn more about MS SQL. Since I use Witango for > almost all my work with the MS SQL is it worth learning more about > stored procedures and XML and HTML and/or extending my knowledge of > transact SQL. > > There are two new books by Ken Anderson that look good but I am not > sure if they are worth getting > > > The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With > CD-ROM) by Ken Henderson > Usually ships in 24 hours > Date Added: December 7, 20 > > > > The Guru's Guide to Transact-SQL by Ken Henderson > Usually ships in 24 hours > Date Added: December 7, 2003 -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com "When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry." ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
