I need to write a MS SQL 2000 Db trigger to do the following but I am new to SQL and have very little experience...
What I need to do is on the insert of any data to a table called docs I need to check the Name of the document contains a certain string of characters e.g Council Minutes etc etc
If it does then i need to extract some further info from a series of fields Folder,Leaf, and a binary field which actually contains the document.
I then need to send these to an HTTP server via an HTTP POST command.
Any thoughts greatly appreciated as I know nothing about this