Re: UPDATETEXT table_name
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 18 Mar 2006 23:49:35 +0100
On Sat, 18 Mar 2006 09:34:29 -0800, VistaCreek wrote:
I am attempting to update a text field using UPDATETEXT
I need the table_name for UPDATETEXT table_name.dest_column_name
However, my SP could be running on ANY database. So like any other query, I
just want it to use the current database.
Hi Brett,
No problem. You don't need to specify databasename or owner for the
UPDATETEXT command; database will default to the current database.
I assume I am not forced to hardcode the table_name value, however, can not
find a way to do this anywhere ...
You have to hardcode the tablename, just as you have to hardcode the
tablename in any INSERT, UPDATE, DELETE or SELECT statement.
--
Hugo Kornelis, SQL Server MVP
.
- Prev by Date: Re: Enterprise Manager 'Change Query Type' Window
- Next by Date: Re: deleting duplicates
- Previous by thread: Re: Enterprise Manager 'Change Query Type' Window
- Next by thread: Re: deleting duplicates
- Index(es):
Relevant Pages
|
