>
> CREATE PROCEDURE update_image_status_y
> (
> @image_id INT
> )
>
> UPDATE images
> SET image_document_head = 'y'
> WHERE id = @image_id
>
>
> But i get a "Incorrect SYntax near the keyword UPDATE" what's up?!
You left out the word "AS":
CREATE PROCEDURE procedure_name (parameters) AS UPDATE ...
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
