We Translate Business Processes from the Mind
to the Computer
to the Bottom Line
.™

 
 
Home
Services
What Can be Done
How To Buy Custom Programs
Job Automation Example
Contact Us
Fellow Programmers
   MS Access
 MS SQL Server
Prius Opinion

All code, utilities, and white papers provided here are as is and are free of charge.  You are allowed to use them as part of your own applications.  If you use my ideas or code, please test them before you hook the code up with real data.  Data is too important to destroy.  If you are going to redistribute any code outside your application, please give Business & Computers, Inc. and Larry Gordon credit for the code, utilities, or white papers along with our website http://www.businessandcomputers.com .

I would like to tell you all the code is original, however that would be a lie.  I read lots of books, have lots of people who have helped me, research many problems and come to my own conclusions.  In doing so I do not believe I have an exact copy of anyone’s code, but you might see different peoples influences in some snippets.  Hopefully I can influence your code in the same way and help make you a better programmer. 
Microsoft SQL Server and Some .Net
B&C
No.
Title
Author
If Other Than Larry Gordon
Date Last Uploaded
Summary File
1

The Basics of Stored Procedures.

This is for people who are just starting SQL Server and want to learn how to write Stored Procedures.

 SQL_StoredProcBasics.pdf
10 How to backup and Maintain your SQL Server. You cannot backup SQL Server with a normal backup program by backing up your mdf file.  This shows how to schedule backups and how to restore the file.  It also show how to schedule some other maintance jobs.  SQL_BackupMaintain.pdf
12 Security and SQL Server  People write whole books on SQL Server, this is just a brief explanation.  You must have some understanding of SQL Server in order to program insid SQL Server.  SQLSecurity.pdf
20 Using XML inside Stored Procedures We show how to receive XML and turn it into a table.  XML_SQL_OpenXML.pdf
21  Brief description on how to move data through web services using .Net and SQL Server

This shows how to move data from one application to another over the web using web services and SQL Server.

 TransmittingDataTo_FromWebUsingSQL_VB.pdf
 30

Access Queries to
   T-SQL Queries

A Access 2000 database and a 2 page pdf file

Updated 02/24/2005

 Very rough code that will chnage Access SQL to
T-SQL for SQL Server.  This is a form you can import into your database, pick a query and print in a box any problems and T-SQL that will work in SQL Server.  You can then copy the T-SQL and use it in a Stored Procedure, View, etc.

 

       AccessQuery_To_TSQL.zip

 

       
       
       
       

 
     
 
 
   
  Go to Top  | Home Email the Programmer at Business & Computers, Inc.  
.     Copyright Copyright © 2004, by Business & Computers, Inc. All rights reserved