Re: Change Column Position

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"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

  • Re: UPDATE Statements May be Replicated as DELETE/INSERT Pairs
    ... I couldn't really tell what was the update statement that caused this ... Looking for a SQL Server replication book? ... Delete/Insert pairs, I was really surprised and couldn't understand ...
    (microsoft.public.sqlserver.replication)
  • RE: Understanding how my code is causing deadlocks!
    ... you can set some trace flags that will give you more detailed ... information when the deadlocks occur. ... > SQL Server and sending it to a web service. ... > - First update statement and select statement are sent to SQL server in one ...
    (microsoft.public.sqlserver.server)
  • Understanding how my code is causing deadlocks!
    ... I have a windows service that has a job of periodically pulling data from ... SQL Server and sending it to a web service. ... - Update statement to update batch of records to be "pulled" ...
    (microsoft.public.sqlserver.server)
  • RE: Understanding how my code is causing deadlocks!
    ... "Kevin Kraus" wrote: ... > SQL Server and sending it to a web service. ... > - First update statement and select statement are sent to SQL server in one ... > My understanding of deadlocks is that my process thread needs to have a lock ...
    (microsoft.public.sqlserver.server)
  • Re: PostgreSQL Query Errors?
    ... >>> Microsoft OLE DB Provider for ODBC Drivers error '80004005' ... > And he is also opening the whole table instead of a single row. ... So it would be better to use an UPDATE statement? ... has worked with SQL Server for a long time. ...
    (microsoft.public.inetserver.asp.db)