Re: UPDATETEXT table_name

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

  • Re: PLEASE HELP: Assign column names to variables
    ... I have designed a form that searches from the current database based on ... criteria that user selects(criterias are column names in the database ... search form) hardcoded in the Select statement. ... select in the form and not hardcode it. ...
    (microsoft.public.access.formscoding)
  • 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)
  • PLEASE HELP: Assign column names to variables
    ... I have designed a form that searches from the current database based on the ... criteria that user selects ... search form) hardcoded in the Select statement. ... select in the form and not hardcode it. ...
    (microsoft.public.access.formscoding)
  • Re: how to determine if date is a Federal holiday
    ... get externally (database, config file, web site) ...
    (microsoft.public.dotnet.languages.csharp)
  • 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)