Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. Benjamin Moore

Benjamin Moore

Community Learner
Share
25Questions
25Answers
37.5KViews on questions

What should I do in an sql case when multiple conditions?

In an sql case when multiple conditions- ,CASE WHEN i.DocValue ='F2' AND c.CondCode IN ('ZPR0','ZT10','Z305') THEN c.CondVal ELSE 0 END as ValueThere are two types of CASE statement, SIMPLE and SEARCHED. You cannot evaluate multiple expressions in a Simple case expression, which is what you were attempting to do. --…

SQL Server

Answered Sep 27, 2022 · 1.4K Views Read answer →

Unable to execute jar- file no main manifest attribute

That should have been java -jar app.jar instead of java -jar "app".The -jar option only works if the JAR file is an executable JAR file, which means it must have a manifest file with a Main-Class attribute in it. See Packaging Programs in JAR Files to learn how to create an executable JAR. If it's not an executable…

Python

Answered Jul 19, 2021 · 2.4K Views Read answer →

Unicode non-breaking space is not considered white space?

The non-breaking space is not whitespace, according to Java. Apex Code uses the same rules as the Java Pattern class to solve u00a0, which specifies s as follows: s A whitespace character: [ ] Where " " is 0x20, is 0x09, is 0x0A, is 0x0B, is 0x0C, and is 0x0D. No other characters are defined as whitespace, despite…

Salesforce

Answered Jul 3, 2021 · 2.5K Views Read answer →

How Instead of trigger Sql server used with Inserted table?

Trigger is just part of the entire transaction. The INSERTED table will hold the records that would have been inserted. The difference between AFTER triggers, which may be causing this confusion, is that INSTEAD OF doesn't verify if the row insert would have caused failures due to any constraints present on the table.…

SQL Server

Answered Apr 24, 2021 · 1.6K Views Read answer →

Why SQL Server port number is not default 1433?

By default sql server port, associated database engine services are TCP 1433, 4022, 135, 1434, UDP 1434. The default port of SQL server is 1433, used when there is only one SQL Server named instance running on the computer. When multiple SQL Server named instances are running, they run by default under a dynamic port…

SQL Server

Answered Apr 24, 2021 · 1.4K Views Read answer →

More members from the SQL Server community

Learners asking and answering questions on the same topics — follow their questions and join in.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.