Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. Dia Shrinidhi

Dia Shrinidhi

Community Learner
Share
16Questions
16Answers
31.3KViews on questions

How to resolve the error of salesforce date literals?

To resolve the error of salesforce date literals - CreatedDate is a datetime field so I guess you would need to specify the time component. Can you do something like where you just append the time portion to be 12 am by default. WHERE CreatedDate > 2005-10-08T00:00:00Z Or you can use Date Literals like WHERE…

Salesforce

Answered Apr 28, 2023 · 1.3K Views Read answer →

Cannot delete or update a parent row: a foreign key constraint fails

The simple way would be to disable the foreign key check; make the changes then re-enable foreign key check. Under your current (possibly flawed) design, you must delete the row out of the advertisers table before you can delete the row in the jobs table that it references The simple way to disable the foreign key…

Python

Answered Jul 14, 2021 · 2.1K Views Read answer →

Function vs. Stored Procedure in SQL Server

To finish an undertaking, information base articles like the put-away systems and Functions contain a bunch of SQL explanations. Function: Function is compiled and executed every time it is called. This cannot modify the data received as parameters and function must return a value. Stored Procedure: This is a…

SQL Server

Answered Mar 5, 2021 · 1.1K Views Read answer →

More members from the Salesforce community

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

Latest Salesforce Blogs

Guides, tips and career advice on Salesforce from JanBask experts.

Learn & Explore

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