M MSSQ L P MSSQ L M MSSQ L P MSSQ L M MSSQ L P MSSQ L M ϒϩάͷهࣄ14,000ສΛݱ ࡏ͍͑ͯΔɻ 1ͭͷDBͰCRUDͷશͯΛࡹ͘ ͷʹݶք͕͋ΔͨΊDBΛ4ׂ ͍ͯ͠Δɻ DB01 → Ϛελʔσʔλ DB02 - 04 → هࣄσʔλ DBͷো͕ൃੜͨ͠ࡍΛߟ͑ ͯϓϦϯγόϧ/ϛϥʔϦϯάߏ
MSSQ L M MSSQ L M MSSQ L P MSSQ L P SELECT @id = CASE WHEN '1' THEN '[DB01].a.dbo.XXXXXXX' WHEN '2' THEN '[DB02].b.dbo.XXXXXXX WHEN '3' THEN '[DB03].c.dbo.XXXXXXX WHEN '4' THEN '[DB04].d.dbo.XXXXXXX END [DB04-Miller].c.dbo.XXXXXXX [DB03].c.dbo.XXXXXX