数据库 条件语句 使用上面是我写的存储过程 里面使用 if 条件语句 下面图片是运行时报的错误。。。 该怎么修改语句呢。。。[解决办法]可以用case...when...then语法来实现你要求的功能，你这种写法没用过！[解决办法]
UPDATE Man SET TaskId = CASE WHEN TaskId IS NULL THEN @TaskId ELSE TaskId END, TaskIdd = CASE WHEN TaskId IS NULL THEN TaskIdd ELSE CASE WHEN TaskIdd IS NULL THEN @TaskId ELSE TaskIdd END ENDWHERE ID = @ManId
IF EXISTS (SELECT 1 FROM Man WHERE ID = @ManId AND TaskId IS NULL)BEGINUPDATE MAN SET TaskId = @TaskId WHERE ID = @ManId AND TaskId IS NULLEND IF EXISTS (SELECT 1 FROM Man WHERE ID = @ManId AND TaskId IS NOT NULL AND TaskIdd IS NULL)BEGINUPDATE Man SET TaskIdd = @TaskId WHERE ID = @ManId AND TaskId IS NOT NULL AND TaskIdd IS NULLEND
