时间戳

首页 > 解决方案 > 消息 156，级别 15，状态 1，第 20 行关键字“或”附近的语法不正确

windows - 消息 156，级别 15，状态 1，第 20 行关键字“或”附近的语法不正确

问题描述

ALTER PROCEDURE [dbo].[sp_GeneralInfo](@Equipment float) 开始
插入 GeneralInfo

    SELECT EQUIPMENT.Equipment, EQUIPMENT.Description, RIGHT(EQUIPMENT.UserStatus, 3) AS Saty,  
    EQUIPMENT.UserStatus, case when EQUIPMENT.UserStatus like'%RNT%'  then 'RENTAL' OR EQUIPMENT.UserStatus like'%T&M%' then 'T&M' AND (EQUIPMENT.UserStatus like'%ORS%' then 'FSMA' OR EQUIPMENT.UserStatus like'%INT%' then 'Internal Use') OR (EQUIPMENT.UserStatus like'%DEMO%' then 'DEMO' AND EQUIPMENT.UserStatus like'%LOAN%' then 'LOAN') end as Saty,

    EQUIPMENT.UserStatus, case when EQUIPMENT.UserStatus like'%MTR%' then 'METRO' end as Location,
    case when EQUIPMENT.UserStatus like'%RMT%' then 'REMOTE' end as Location,
    EQUIPMENT.Saty, EQUIPMENT.ObjectType, EQUIPMENT.PG, ZSMR056.SDM, EQUIPMENT.AccountCategory, EQUIPMENT.Location, ZSMR056.ServiceCa, EQUIPMENT.CurrentMeter
    FROM  EQUIPMENT INNER JOIN ZSMR056 ON 
    EQUIPMENT.Equipment = ZSMR056.Equipment

    WHERE EQUIPMENT.proses = 0 AND ZSMR056.proses = 0

END

标签： windows

解决方案

推荐阅读