SEO

#1 (**permalink**) 02-28-2008, 07:09 PM

Hi all,

I am using following update command but getting error on database field
name. I can't change the database filed name, please give me idea how can
I use reserved word in this statement.

update ws_apps
set database = 'EFORMS'
where app_id=4

Thanks for your help

#2 (**permalink**) 02-28-2008, 07:09 PM

hqureshi1103@rogers.com (Adnan Jamil) wrote:
>Hi all,
>I am using following update command but getting error on database field
>name. I can't change the database filed name, please give me idea how can
>I use reserved word in this statement.
>
>update ws_apps
>set database = 'EFORMS'
>where app_id=4
>
Try:
update ws_apps
set [database] = 'EFORMS'
where app_id=4

HTH,
Myron

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Newbie Question