Re: UPDATETEXT table_name

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
.

Relevant Pages

  • DBI:mysql -> using .my.cnf
    ... I'm trying to connect to a database "ipp", and rather than hardcode the ... google-surfing, the following should work: ...
    (comp.lang.perl.modules)
  • Restore database without providing a name??/
    ... database name in the restore command? ... but right now I hardcode the database name ... into the restore command. ... different names and I don't want to have to prompt the user to enter ...
    (microsoft.public.sqlserver.server)
  • Re: Need Help in QUERY
    ... database. ... So we can't Hardcode that in the QUERY. ... > - Anith ...
    (microsoft.public.sqlserver.programming)
  • Re: Need Help in QUERY
    ... database. ... So we can't Hardcode that in the QUERY. ... > - Anith ...
    (microsoft.public.sqlserver.programming)
  • MSSQL 2000 JDBC Driver Bug in get/setTimestamp using Calendar
    ... I am trying to set my time stamps in GMT into the database. ... Whether I am reading or writing the date, the driver jumps ahead with one ... String tableName) ... insertStmt.setString(2, insertedGMTValue); ...
    (microsoft.public.sqlserver.jdbcdriver)