Is this what you're aiming for? To select where in SQL, make sure the fields that are being compared are comparable (i.e. both fields are numeric, text, boolean, etc). SELECT * FROM Individual INNER JOIN Publisher ON Individual.IndividualId = Publisher.IndividualId WHERE Individual.IndividualId = (SELECT someID FROM…
Answered Sep 29, 2022 · 1.1K Views Read answer →
To solve sql server snapshot maybe you have used the wrong code. [...] Perhaps the biggest hindrance to adoption is that Management Studio didn't offer support[...]By this he meant that you do not have a feature in SSMS to create a snapshot of a database, you have to rely on SQL command to create database snapshot.…
Answered Aug 28, 2021 · 1.3K Views Read answer →
You should try to avoid sql server loop through tables generally. They are normally less efficient than set based solutions as well as less readable. The below should be pretty efficient. Even more so if the name and weight columns could be INCLUDE-d in the index to avoid the key lookups. It can scan the unique index…
Answered Aug 27, 2021 · 1.6K Views Read answer →
I was facing a salesforce developer login issue for many days. The problem was that I forgot to deploy the custom domain to users after it was approved. And if you go to My Domains settings, from there you need to finalize the process by deploying the my domain to users. After that the login.salesforce.com started…
Answered Aug 25, 2021 · 1.4K Views Read answer →
Please check this dev forum link. You need to upload a single file that contains the godaddy intermediate certificates, Intermediate CA Certificate and then the Root CA Certificate in that order. 1.Open a Notepad or any Text Editor. 2.Paste each certificate as per below order.-----BEGIN CERTIFICATE----- (SSL…
Answered Jul 22, 2021 · 1.5K Views Read answer →
ora 00920 problem may be this Salesforce known issue: A formula field with a result of NULL causes SOQL retrieval to fail as it includes the same exception and is about formula fields. Until that is fixed, change your formula to never return null as described in the known issue: Workaround Ensure the formula result is…
Answered Jul 19, 2021 · 1.5K Views Read answer →
The mainstream support for SQL Server 2012 ended on 9 January 2018. Its extended support will end on 12 July 2022. The lifecycle policy for Microsoft products is generally that the support for the previous Service Pack expires 12 months after the new Service Pack was released to the public. So if the SQL Server 2012…
Answered Jul 12, 2021 · 1.3K Views Read answer →
I've used Openrowset a number of times for this task. import data from excel to sql server using query code will create a table in SQL. SELECT * INTO EXCEL_IMPORT FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0; Database=C:ExcelSpreadsheet.xls; HDR=YES; IMEX=1', 'SELECT * FROM [Sheet1$]');Ideally you want to…
Answered Jul 12, 2021 · 1.2K Views Read answer →
Yes, it can be done. You're thinking that an RSA authenticator (hardware or software token) can be used in a plug-and-play manner similar to Google or Salesforce authenticator. That is not the case. SecurID is fundamentally a different animal, it uses its own protocols and requires RSA server software. The overall…
Answered Jul 12, 2021 · 1.3K Views Read answer →
If you want get all keys from json, you can use this code:`string jsonString = '{"CompletedAt":null, "Scaled":null, "Raw":null, "Min":null, "Max":null, "TotalTimeTicks":null, "Location":null, "SuspendData":null}'; Matcher m = Pattern.compile('\"([^"]*)\":').matcher(jsonString); List keysInJson = new List(); while…
Answered Jul 10, 2021 · 1.5K Views Read answer →
First question arrives, Why does this warning message occur in the first place? It can be due to Incorrect default value of core.autocrlf on Windows. Now let us discuss the meaning of two types of warning messages, First warning message is 'LF will be replaced by CRLF', this warning message says that you will lose…
Answered Jun 27, 2021 · 2.6K Views Read answer →
Just Remove the extension .txt from Dockerfile and run the command docker build -t image-nameIt will work for unable to evaluate symlinks in dockerfile path error.
Answered Apr 30, 2021 · 1.9K Views Read answer →
Learners asking and answering questions on the same topics — follow their questions and join in.
Salesforce learner
103Questions 162AnswersSalesforce learner
86Questions 128AnswersCyber Security learner
75Questions 203AnswersCyber Security learner
70Questions 158AnswersSalesforce learner
67Questions 79AnswersSQL Server learner
64Questions 66AnswersGuides, tips and career advice on Salesforce from JanBask experts.
Salesforce How to Become a Salesforce Developer Without Experience
No coding background? Learn how to become a Salesforce Developer step by step - skills to build, projects to create, and how to…
Salesforce How to Become a Salesforce Admin With No Experience
No Salesforce Admin experience? Learn how to build real skills, create projects, and land an entry-level Salesforce Admin job…
Salesforce How Long Does It Take to Become a Salesforce Developer?
Wondering how long to learn Salesforce Developer? Most beginners need 6–12 months. See the study time, stage-by-stage roadmap and…
Salesforce How Long Does It Take to Become a Salesforce Admin?
Wondering how long to learn Salesforce Admin? Most beginners need 3–6 months. See the study time, stage-by-stage roadmap and…
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step Salesforce guides from industry experts
Common Salesforce interview questions, answered
