Category Archives: Databases

Two ways to fake a SQL table [SQL]

The first way is to create a temporary table and insert values into it. DECLARE @declareTable TABLE (seq int, name VARCHAR(5) ) ; INSERT INTO @declareTable (seq,name) values (1,’one’), (2,’two’), (3,’three’) select * from @declareTable as dt; The second way is to create the values inside the select statement. select * from (values (1,’one’), (2,’two’),… Read More »

Convert FoxPro to Microsoft SQL Server

The easiest way to convert FoxPro to Microsoft SQL Server is to copy the FoxPro file to a CSV and use the SQL Server Import and Export Wizard. In FoxPro use NameOfFile (or ?) copy to NameOfFile type csv This will give you a clean CSV with a header line.