Quote:
Can you please explain me the part 17), 18) and 19) ?
At the pasting in the query analyzer it says syntax error in the near of WHERE.
and if this works, what to do at 18 and 19? >.<
USE [account]; GO UPDATE dbo.user_profile SET login_flag = 0, WHERE (login_flag[color=red]0[/color] = 1100);
then comesQuote:
USE [account];
GO
UPDATE dbo.user_profile
SET login_flag = 0,
WHERE (login_flag = 1100);
pls help.Quote:
Server: Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'WHERE'.