Go to Qiita Advent Calendar 2024 Top

5

More than 5 years have passed since last update.

Sql serverのSelect文でIF文 (は、つかえない)

SQLServer

Last updated at 2013-03-13Posted at 2013-03-13

使えないからこんな感じにするとできた。

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

5

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

What you can do with signing up

5