Why UPDATE()

MikeONeillMikeONeill Posts: 131
edited November 2, 2007 3:15AM in SQL Prompt Previous Versions
when I type UPDATE , automatically get a pair of brackets ()

Is this a bit of SQL I don't know

It isn't set as a snippet , so I can't edit it

Any Ideas

ta Mike

Comments

  • Thanks for your post.

    If it is a bit of SQL you don't know, then I have to admit that I don't know it either.

    Does this happen consistently and on every database? The only way I have managed to recreate the issue is if I create a function in my database called 'update', then type something like select dbo.update

    What is the SQL you are typing that is causing UPDATE to be followed by parenthesis? If you restart SQL Prompt, does the problem still occur?

    Are you using SQL Prompt 3.6?
    Chris
  • UPDATE() is for use in triggers to determine if a particular column has been inserted or updated, e.g.

    IF UPDATE(customer_id) BEGIN
    ...
    END
  • Thanks Dave

    Guess I should read the help files a bit more , I did actually find after I had posted , on the suggestions list it shows a Function symbol

    All that said , as bit of SQL I didn't know about to have it as the default for one of the more common SQL Functions is a bit irritating . I can get around it obvioulsy but to hav ethe standard UPDATE as the default would be preferable

    Cheers
    Mike
Sign In or Register to comment.