使えないから こんな感じにするとできた。
this
SELECT case when max([NUM]) is NULL then 0 else max([NUM]) + 1 end as NUM
FROM [hoge].[huge].[fuge]
where ID='99'
書いてあった場所
http://detail.chiebukuro.yahoo.co.jp/qa/question_detail/q1250933162
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme
List of users who liked
55