What are you wanting to know specifically and what programming language? There are lots of examples on the web of all types of connection and execution methods. I prefer to wrap all the processing I can into SPs and build the business logic into the client as much as possible just for performance reasons. However, I have done a lot of business logic SQL side too. I just am not sure what you are looking for.