Re: MS SQL Server vs MySQL

Quoting [email protected]:

> The problem I'm having is just getting MS SQL to do what I want, when
> MySQL does it without a problem.  For example, I tried to import data
> from a delimited file into MS SQL server.  What a pain it was!  Even
> with their "wizard" it was harder than using a mySQL command line cause
> the wizard didn't work as expected.

Take a look at bcp. There is also the BULK INSERT command. Both of 
those can be
run without using the data import/export wizard, which, by the way, is Data
Transformation Services, an add-on to SQL Server. It gets beefed up as SQL
Server Integration Services in SQL Server 2005.

>
> Once I finally got data into a table, I wanted to move it to another,
> like this:
>
> Insert into newtable select field1, field12, ... Field6 from oldtable;
>

I'm assuming you used SELECT INTO. You can specify a NULL value, however, you
must still give the column name using an alias. An example would be:

USE Northwind
GO

SELECT OrderID, CustomerID, EmployeeID, NULL [NullableColumn]
INTO OrderTransfer
FROM Orders

-- 
K. Brian Kelley,  [email protected]
Enterprise Systems Architect/DBA, AgFirst Farm Credit Bank
Author: Start to Finish Guide to SQL Server Performance Monitoring
Contributing Author: Best of SQLServerCentral.com Series
Regular Columnist (Security): SQLServerCentral.com and SQL Server Standard
Magazine
Member, SANS GIAC Advisory Board
http://www.truthsolutions.com/



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]