• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

looking for book using C for SQL maintenance

I have to create some scheduled tasks for database maintenance.
I'm looking for a book with lots of example C code for interacting with SQL Server.
I have the Microsoft ODBC Programmer's Reference already, I would like something with lots of complete examples.   I don't mind spending the boss' money
0
jnearing
Asked:
jnearing
1 Solution
 
jbiswasCommented:
Doing database maintenance work with C is kinda cumbersome. I have worked in this field long enough and have not come across anything which discusses similar things. I have a suggestion though..why don't you try using Perl instead. It is a very easy language to learn and it is very easy to do DBA kinda work with Perl. In case you are not doing anything fancy I might even be able to give you some scripts.
Jit
0
 
jnearingAuthor Commented:
What I need to do isn't very complicated SQL wise, but a little to big to fit in an ISQL statement in the scheduled task mgr.

Typical of what I want to do is join a couple tables, select certain records that need be moved to another table.

I wouldn't mind doing it in Perl if that's the path of least resistance but I need to get it working sometime yesterday.

If you can, send me something along the lines above, it has to be able to run as a CmdExec in the task scheduler.

You'll notice that I spelled Perl correctly, that's about the extent of my knowledge.   I think I have a book at home though.

thanks

0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now