Re: Change Column Position

Thankxx for the reply.

Data is exported to a text file from client and then imported into the sql
server from text file through a third party application made in vb6. The
columns position in the text file creates problem while importing. So it is
possible to change the columns positions in the table???

Regards,
Muhammad Bilal



"Rick Sawtell" wrote:


"Muhammad Bilal" <MuhammadBilal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7EAA3D3B-AAEA-4920-9310-0CEDAD0DEECE@xxxxxxxxxxxxxxxx
Hi.

How to change the position of the column in a table in SQl Server 2000.


Regards,
Muhammad Bilal

In your SELECT or INSERT or UPDATE statement, simply put the column in the
place that you wish it to be. The column order in the table is most likely
NOT the way SQL Server will store the data internally, so moving a column
around really has no validity.


Rick Sawtell
MCT, MCSD, MCDBA, MCITPro





.

Relevant Pages

  • Text file, SAP and multi language support problems????
    ... I have been having difficulties for many months now when importing text data ... that is exported from SAP then FTP's from a UNIX server to my SQL server. ... contains 6 columns and the first row contains data only in the first 5 ...
    (microsoft.public.sqlserver.dts)
  • Please HELP! text import problems.
    ... I have been having difficulties for many months now when importing text data ... that is exported from SAP then FTP's from a UNIX server to my SQL server. ... contains 6 columns and the first row contains data only in the first 5 ...
    (microsoft.public.sqlserver.dts)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)