Re: Newbe question
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 04/30/03
- Next message: John Michale: "sqlserver and certificates."
- Previous message: Wayne Gore: "Newbe question"
- In reply to: Wayne Gore: "Newbe question"
- Next in thread: Vishal Parkar: "Re:Newbe question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 30 Apr 2003 09:07:25 -0400
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: John Michale: "sqlserver and certificates."
- Previous message: Wayne Gore: "Newbe question"
- In reply to: Wayne Gore: "Newbe question"
- Next in thread: Vishal Parkar: "Re:Newbe question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
