Cursors in Stored Procedures
First, let's define a stored procedure for those who don't already know. A stored procedure is basically a query that you would run frequently that you have saved. The power is that you can have input parameters. For example, if you always execute this query: Directory:
> IT > Database
Date: 2002-02-20
|
How to Import FoxPro 2.x Tables into Microsoft SQL Server
First off, let's explain a little about the common situation that this "how to" is targeted towards. FoxPro 2.x was a big part of many applications in the early 90's and those applications ran/run just fine. However, compared to SQL Server 2000, or any other modern DBMS, it's a joke. Directory:
> IT > Database
Date: 2002-02-06
| |
|