Formating UPDATE command

How can I change the format option for UPDATE command to produce code like this
UPDATE table
SET
field1 = @field1,
field2 = @field2,
etc.

Now after selecting the table it appears
UPDATE table
SET
field1 = ?,
field2 = ?.
etc.
Thank's
Sorin

I believe you are confusing code formatting, code auto-expansion and code snippets.

Theoretically the best way to do what you want would be to define a new "active" code snippet, for example, up and enter something like the following

	Code:
	DECLARE @$COLUMNS+TYPES$ UPDATE $OBJECT$ SET $COLUMNS$ = @$COLUMNS$

So if you type up then press Ctrl+Enter, you get a prompt to choose table name, and after that you get the required update statement.

Unfortunately in the latest beta build we do not yet support active snippets in UPDATE and INSERT statements. This will be available sometime later.

By the way, this technique can be already used for INSERT statements

	Code:
	INSERT INTO $OBJECT$ ( $COLUMNS$ ) VALUES ( @$COLUMNS$ )

And also by the way, if you don't want the UPDATE statement to be expanded you can either disable that particular feature or hold down the Shift key when selecting object name from a popup after UPDATE keyword.