Re: Newbe question
From: Vishal Parkar (vgparkar_at_hotmail.com)
Date: 04/30/03
- Next message: Jasper Smith: "Re: sqlserver and certificates."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 30 Apr 2003 09:19:16 -0700
This is more smart than what i've posted :)
--Vishal
>-----Original Message-----
>Please post your DDL in the future. Would the following
work?
>
>update MyTable
>set
> Col3 = Col2
>, Col2 = NULL
>
>--
>Tom
>
>----------------------------------------------------------
-----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada tom@cips.ca
>www.pinnaclepublishing.com/sql
>
>
>"Wayne Gore" <wayne.gore@spray.se> wrote in message
news:eOFebaxDDHA.2596@TK2MSFTNGP11.phx.gbl...
>Hi
>
>I have a table with 3 columns.
>The first column is an ID column with identity on (seed
1).
>The second column contains data that I want to move to
the third column.
>The data that is moved should be in the same row as
before.
>When the data has been moved then the second column
should not contain any
>data at all (but still exist).
>
>Any ideas?
>
>Regards
>Rickard
>
>
>
- Next message: Jasper Smith: "Re: sqlserver and certificates."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
