什么是标签注释在pom.xml中的好处？(What are tag comments good for in pom.xml?)
我目前正在浏览https://spring.io/guides/gs/maven/#scratch ，我刚刚找到
<dependencies> <!-- tag::joda[] --> <dependency> <groupId>joda-time</groupId> <artifactId>joda-time</artifactId> <version>2.9.2</version> </dependency> <!-- end::joda[] --> <!-- tag::junit[] --> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> <!-- end::junit[] --> </dependencies>我想知道：
什么是
<!-- tag::joda[] -->吗？I'm currently going through https://spring.io/guides/gs/maven/#scratch and I just found
<dependencies> <!-- tag::joda[] --> <dependency> <groupId>joda-time</groupId> <artifactId>joda-time</artifactId> <version>2.9.2</version> </dependency> <!-- end::joda[] --> <!-- tag::junit[] --> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> <!-- end::junit[] --> </dependencies>and I wonder:
What is
<!-- tag::joda[] -->good for?
原文：https://stackoverflow.com/questions/44782273
更新时间：2023-11-03 07:11
最满意答案
比@ SpaceUser7448简化得更像这样：
SELECT CASE WHEN 'FIELD1' LIKE 'VAL1' THEN 'M' WHEN 'FIELD1' LIKE 'VAL2' THEN 'Q' WHEN 'FIELD1' LIKE 'VAL3' THEN 'Y' ELSE 'T' END AS 'VAL4'Simplified further than @SpaceUser7448 this would look like:
SELECT CASE WHEN 'FIELD1' LIKE 'VAL1' THEN 'M' WHEN 'FIELD1' LIKE 'VAL2' THEN 'Q' WHEN 'FIELD1' LIKE 'VAL3' THEN 'Y' ELSE 'T' END AS 'VAL4'
相关问答
更多-
请在外部选择中选择相同。 您不能在同一个查询中访问别名。 SELECT *, (CASE WHEN articleNumber < 2 THEN 'Ama' WHEN articleNumber < 5 THEN 'SemiAma' WHEN articleNumber < 7 THEN 'Good' WHEN articleNumber < 9 THEN 'Better' WHEN articleNumber < 12 ...
-
进入时的TSQL计数案例(TSQL Count Case When In)[2022-05-01]
也许是这样的？ SELECT COUNT(*) FROM .... WHERE ID NOT IN (SELECT DISTINCT ID FROM ...) Maybe something like this? SELECT COUNT(*) FROM .... WHERE ID NOT IN (SELECT DISTINCT ID FROM ...) -
SELECT Client, CASE WHEN [Closed] <= @GivenDate THEN 'Closed' WHEN [Closing] <= @GivenDate THEN 'Closing' WHEN [Live to Terminal] <= @GivenDate THEN 'Terminal' WHEN [Prospect to Live] <= @GivenDate THEN 'Live' ELSE 'Prospect' END Status FR ...
-
TSQL - 案例日期比较(TSQL - Case Date Compare)[2023-01-21]
为什么不直接比较日期？ CASE WHEN DATEDIFF(day, FieldDate, GETDATE()) = 0 THEN 1 ELSE 0 END AS tmpDate Why not compare the dates directly? CASE WHEN DATEDIFF(day, FieldDate, GETDATE()) = 0 THEN 1 ELSE 0 END AS tmpDate -
GROUP BY与CASE - tsql(GROUP BY with CASE - tsql)[2023-12-01]
我相信CTE会简化你想要做的事情： ;WITH WT AS ( SELECT ReportingDate , PortfolioID , PortfolioNme , CASE WHEN @ReportType = 'GeoCountry' THEN Infoportal.dbo.fn_Generic_ProperCase(Country) WHEN @ReportT ... -
tSQL CASE来控制执行(tSQL CASE to control execution)[2022-01-13]
不， CASE表达式不能用于控制Transact-SQL语句，语句块，用户定义函数和存储过程的执行流程。 有关流控制方法的列表，请参阅控制流语言（Transact-SQL） 。 No, the CASE expression can not be used to control the flow of execution of Transact-SQL statements, statement blocks, user-defined functions, and stored procedures. F ... -
TSQL的情况(TSQL where case)[2023-01-16]
select * from [table] where case when var_c = 'something' then var_a else var_b end = '10' SQL小提琴演示 。 select * from [table] where case when var_c = 'something' then var_a else var_b end = '10' SQL Fiddle with demo. -
比@ SpaceUser7448简化得更像这样： SELECT CASE WHEN 'FIELD1' LIKE 'VAL1' THEN 'M' WHEN 'FIELD1' LIKE 'VAL2' THEN 'Q' WHEN 'FIELD1' LIKE 'VAL3' THEN 'Y' ELSE 'T' END AS 'VAL4' Simplified further than @SpaceUser7448 this would look like: SELECT CAS ...
-
不是你描述的方式...... 另一种方法是使用isnull()或coalesce() ： select SelectedDate = coalesce(date1,date2) , [Day] = coalesce(day1,day2) , [Hour] = coalesce(hour1,hour2) , [Minute] = coalesce(minute1,minute2) from t Not in the way you are descri ...
-
案例中的TSql案例(TSql Case within Case)[2022-05-07]
根据您的示例，您可能希望使用IF语句（这是ELSE的示例，但您也可以多次使用IF和ELSE IF）： declare @searchField varchar(50) declare @searchString varchar(50) declare @searchOper varchar(50) IF @searchField='CompanyName' BEGIN IF @searchOper='eq' BEGIN select * from tbl1 where ...