[SQL] Re: Toggle a Bit type ie not field

2001-03-21 Thread Brent Verner
On 20 Mar 2001 at 23:07 (-), Peter Morgan wrote: | Here's the SP that toggles a Bit datatype. How would I make it comething | like | ??? | update pcpmanufacturers set def = not (def) where ManufID = @ManufID update pcpmanufacturers set def=(1-def) where ManufID=@ManufID; hth. brent

[SQL] Re: Bruce's Book and Built-in Functions

2001-01-16 Thread Brent Verner
On 16 Jan 2001 at 20:40 (-0800), Josh Berkus wrote: | So, while I wait for my copy ... I can't find in the online | docs anywhere a comprehensive list of built-in functions. | You know, stuff like CURRVAL() and NOW(). Can anyone point | me to such a list? Guessing parameters is getting | frustr