带有选择CASE的SQL查询

本文介绍了带有选择CASE的SQL查询的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好， 我有以下查询:

Hi Everyone, I have the following query:

INSERT INTO dbo.FTA_ReportFileDumpNew select A.MobileNo,A.CustomerName,A.Product,A.Suk_Type,A.FTR_Date,A.FTA_Date, A.Sim_No,A.IMSI_No,A.Retailer_No,A.RetailerName,A.MacMobile_No,A.MacPrimary, A.MacLocation,A.HUB,A.CombinedZone,A.TM_Name,A.TM_Number,A.RETAILER_SMS_DATE, A.CUSTOMER_SMS_DATE,A.[TAT/Hrs],A.[TAT/Mins],A.MinuteWiseData,GETDATE(),'Mobile No. Range is Invalid' from dbo.FTA_ReportFileDump A WHERE LEN(A.MobileNo) <> 10 INSERT INTO dbo.FTA_ReportFileDumpNew select A.MobileNo,A.CustomerName,A.Product,A.Suk_Type,A.FTR_Date,A.FTA_Date, A.Sim_No,A.IMSI_No,A.Retailer_No,A.RetailerName,A.MacMobile_No,A.MacPrimary, A.MacLocation,A.HUB,A.CombinedZone,A.TM_Name,A.TM_Number,A.RETAILER_SMS_DATE, A.CUSTOMER_SMS_DATE,A.[TAT/Hrs],A.[TAT/Mins],A.MinuteWiseData,GETDATE(),'Sim No. Range is Invalid' from dbo.FTA_ReportFileDump A WHERE LEN(A.Sim_No) <> 20 INSERT INTO dbo.FTA_ReportFileDumpNew select A.MobileNo,A.CustomerName,A.Product,A.Suk_Type,A.FTR_Date,A.FTA_Date, A.Sim_No,A.IMSI_No,A.Retailer_No,A.RetailerName,A.MacMobile_No,A.MacPrimary, A.MacLocation,A.HUB,A.CombinedZone,A.TM_Name,A.TM_Number,A.RETAILER_SMS_DATE, A.CUSTOMER_SMS_DATE,A.[TAT/Hrs],A.[TAT/Mins],A.MinuteWiseData,GETDATE(),'Customer name should not be blank' from dbo.FTA_ReportFileDump A WHERE A.CustomerName IS NULL

---------------- 任何人都可以建议我如何在上述查询中使用"CASE". 问候， Raj

---------------- Can any one suggest me how to use the "CASE" for the above query. Regards, Raj

推荐答案

以下是在select查询中使用case语句的示例， The following is the sample for using the case statement in select query, SELECT Product, CASE WHEN isnull(A.CustomerName,'') in('') THEN Customer name should not be blank' WHEN LEN(A.MobileNo) not in (10) THEN 'Mobile No. Range is Invalid' WHEN LEN(A.Sim_No) not in (20) THEN 'Sim No. Range is Invalid' END from dbo.FTA_ReportFileDump A

尝试根据您的要求实施. 希望对您有帮助.....

Try to implement this for your requirement. Hope this will help you.....

CASE可以在允许有效表达式的任何语句或子句中使用.例如，您可以在SELECT，UPDATE，DELETE和SET等语句以及select_list，IN，WHERE，ORDER BY和HAVING等子句中使用CASE. INSERT语句中不使用大小写. CASE can be used in any statement or clause that allows a valid expression. For example, you can use CASE in statements such as SELECT, UPDATE, DELETE and SET, and in clauses such as select_list, IN, WHERE, ORDER BY, and HAVING. Case is not used in INSERT statement.