Home
|
Weblogs
|
Forums
|
SQL Server Links
Search:
Active Forum Topics
|
Popular Articles
|
All Articles by Tag
|
SQL Server Books
|
About
SQL Server Forums
Profile
|
Register
|
Active Topics
|
Members
|
Search
|
Forum FAQ
Register Now
and get your question answered!
Username:
Password:
Save Password
Forgot your Password?
All Forums
SQL Server 2000 Forums
SQL Server Development (2000)
Update Query
New Topic
Reply to Topic
Printer Friendly
Author
Topic
doggi3
Yak Posting Veteran
62 Posts
Posted - 09/14/2004 : 06:06:35
Hi, I will like some advise on update query.
I have Column_A and Column_B in Table_1. I will like to append data from Column_A to Column_B.
From
Column_A | Column_B
A | B
To
Column_A | Column_B
| B A
In the result, Column_A becomes null.
I wrote a query like this:
Update Column_B + Column_A
From Table_1
Where Column_A <> ""
There is error with the query and I am sure the first sentence is wrong. However, I do not know how to append the data from the Column_A to Column_B.
Can any kind-hearted help? Thank you!
- HELP -
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts
Posted - 09/14/2004 : 06:23:10
Update Table_1
set Column_B = Column_B + Column_A
Where Column_A is not null
Something like that maybe?? Although Column_A will still have the original value in...
doggi3
Yak Posting Veteran
62 Posts
Posted - 09/14/2004 : 06:24:51
Thank you so much!
Can I set Column_A to null at the same time, in a single query?
Or do I write another query?
- HELP -
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts
Posted - 09/14/2004 : 06:38:13
You can do it in a single query...
Update Table_1
set Column_B = Column_B + Column_A, Column_A = null
Where Column_A is not null
doggi3
Yak Posting Veteran
62 Posts
Posted - 09/14/2004 : 10:54:07
Thank You So Much~ ^-^
- HELP -
Topic
New Topic
Reply to Topic
Printer Friendly
Jump To:
Select Forum
General SQL Server Forums
New to SQL Server Programming
New to SQL Server Administration
Script Library
Data Corruption Issues
Database Design and Application Architecture
SQL Server 2012 Forums
Transact-SQL (2012)
SQL Server Administration (2012)
SSIS and Import/Export (2012)
Analysis Server and Reporting Services (2012)
Replication (2012)
Availability Groups and DR (2012)
Other SQL Server 2012 Topics
SQL Server 2008 Forums
Transact-SQL (2008)
SQL Server Administration (2008)
SSIS and Import/Export (2008)
High Availability (2008)
Replication (2008)
Analysis Server and Reporting Services (2008)
Other SQL Server 2008 Topics
SQL Server 2005 Forums
Transact-SQL (2005)
SQL Server Administration (2005)
.NET Inside SQL Server (2005)
SSIS and Import/Export (2005)
Service Broker (2005)
Replication (2005)
High Availability (2005)
Analysis Server and Reporting Services (2005)
Express Edition and Compact Edition (2005)
Other SQL Server Topics (2005)
SQL Server 2000 Forums
SQL Server Development (2000)
SQL Server Administration (2000)
Import/Export (DTS) and Replication (2000)
Transact-SQL (2000)
Analysis Services (2000)
MSDE (2000)
Development Tools
ASP.NET
Reporting Services Development
Other Development Tools
Site Related Forums
Site Related Discussions
Article Discussion
Poll Discussion
The Yak Corral
Other Forums
SQL Server 6.5 \ SQL Server 7.0
Other Topics
MS Access
ClearTrace Support Forum
Old Forums
CLOSED - General SQL Server
CLOSED - SQL Server 2005/Yukon
--------------------
Home
Active Topics
Frequently Asked Questions
Member Information
Search Page
SQL Server Forums
© 2000-2009 SQLTeam Publishing, LLC
This page was generated in 0.03 seconds.
Update Query
Posted - 09/14/2004 : 06:06:35
