|
Home > Archive > Microsoft SQL Server forum > February 2006 > SQL command needed to edit table data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL command needed to edit table data
|
|
| News East 2006-02-25, 9:45 am |
| I have an existing SQL 7 server named HHARBR. HHARBR has a database named
SPR with a table named "reportname" in it, the table has the name HHARBR
embedded the table data.
I migrated the HHARBR database SPR to a second server called HHARBR2. When I
look into the table in HHARBR2 I still see the name HHARBR in the data.
What command can I run on HHARBR2 to change the table entries of HHARBR to
the new server name of HHARBR2?
I prefer something I can run in the Query Analyzer
Source server: HHARBR
Source Database: SPR
Source Datbase Table: reportname
Destination Server: HHARBR2
Destination Databse: SPR
Destination Table: reportname
Summary:
Change wrong server name in destination server to reflect the destinations
server name
| |
| Tom Moreau 2006-02-25, 9:45 am |
| You didn't give us the column with the reportname table. It'll go something
like:
update reportname
set
MyCol = 'HHARBR2'
where
MyCol = 'HHARBR'
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"News East" <Methu969@yahoo.com> wrote in message
news:cX7Lf.171257$WH.96105@dukeread01...
I have an existing SQL 7 server named HHARBR. HHARBR has a database named
SPR with a table named "reportname" in it, the table has the name HHARBR
embedded the table data.
I migrated the HHARBR database SPR to a second server called HHARBR2. When I
look into the table in HHARBR2 I still see the name HHARBR in the data.
What command can I run on HHARBR2 to change the table entries of HHARBR to
the new server name of HHARBR2?
I prefer something I can run in the Query Analyzer
Source server: HHARBR
Source Database: SPR
Source Datbase Table: reportname
Destination Server: HHARBR2
Destination Databse: SPR
Destination Table: reportname
Summary:
Change wrong server name in destination server to reflect the destinations
server name
| |
| Erland Sommarskog 2006-02-25, 9:45 am |
| News East (Methu969@yahoo.com) writes:
> I have an existing SQL 7 server named HHARBR. HHARBR has a database named
> SPR with a table named "reportname" in it, the table has the name HHARBR
> embedded the table data.
>
> I migrated the HHARBR database SPR to a second server called HHARBR2. When
I
> look into the table in HHARBR2 I still see the name HHARBR in the data.
>
> What command can I run on HHARBR2 to change the table entries of HHARBR to
> the new server name of HHARBR2?
>
> I prefer something I can run in the Query Analyzer
>
> Source server: HHARBR
> Source Database: SPR
> Source Datbase Table: reportname
>
> Destination Server: HHARBR2
> Destination Databse: SPR
> Destination Table: reportname
>
> Summary:
> Change wrong server name in destination server to reflect the destinations
> server name
Rather than having the servername in a table, you could @@servername.
As a compromise you could change the column to a computed column:
col AS @@servername
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
|
|
|
|
|