Use the SQL Server getdate tool to export the database objects definition to a SQL file which should include: tables, views, triggers, SPs, functions, and so on Edit the SQL file (make a backup first) using any text editor that allows you to find the text "GETDATE()" and replace it with "[dbo].[getlocaldate]()" Run…
Answered Jul 12, 2021 · 226 Views Read answer →
I am adding this answer as it could be helpful in solving sql server 2014 standard and related to Inplace upgrade First you require to check using the link Thomas gave whether the in place upgrade you are doing is supported or not. After you are sure you meet the upgrade matrix you can proceed with two…
Answered Jul 12, 2021 · 306 Views Read answer →
below: My intent was to make it easier for people to setup environments that demonstrate the SQL problem they are attempting to solve, then post the link to StackOverflow (or something similar) and have people go there and attempt to solve it, much the same as jsfiddle.net is used to solve JavaScript questions. Hope…
Answered Jul 12, 2021 · 317 Views Read answer →
This error indicates that the element you were trying to select was not found (hence, it cannot find the “style” property for element, probably assigned to a variable - it is null, as in empty). Two possibilities here: you might have fired your script before the selector element began to exist in DOM. In your senario…
Answered Jul 12, 2021 · 365 Views Read answer →
You need to pass in your parameters in the body, https www salesforce com login. The request going over the wire should look like this: POST /services/oauth2/token HTTP/1.1 Host: login.salesforce.com Content-Length: ### Content-Type: application/x-www-form-urlencoded Accept: application/json…
Answered Jul 12, 2021 · 298 Views Read answer →
Naming convention in Salesforce is a rule to follow as you decide what to name your identifiers like class, variable, constant, method, etc. But, it is not forced to follow. So, it is known as convention not rule. Naming conventions make the application easier to read and maintain. The default values are component,…
Answered Jul 12, 2021 · 1.4K Views Read answer →
If you are using Data Loader to Update a field in Salesforce with Null Values, then first you need to set the 'Insert Null Values' to true Open Data LoaderClick SettingsSelect Insert Null ValuesClick OK This way you can update the Empty String in .csv for salesforcw BULK APIs
Answered Jul 10, 2021 · 341 Views Read answer →
To solve sql count with condition, you can't limit the query itself with a WHERE clause. But you can use the count aggregate as it only counts the non-null values. So, use this code: SELECTcount (case Position when 'Manager' then 1 else null end) FROM Table_NameYou can also use the sum aggregate in a similar way:…
Answered Jul 8, 2021 · 1 Views Read answer →
Diffie-Hellman is a way of generating a shared secret between two people in such a way that it can't be seen by observing the communication. That's an important distinction You're not sharing information during the key exchange, you're creating a key together. This is useful because you can use this technique to…
Answered Apr 24, 2021 · 9 Views Read answer →
Unfortunately, there is no way. SQL Server MVP Erland Sommarskog has a series of brief* articles on the subject of handling errors in SQL Server that starts here: Error and Transaction Handling in SQL Server The issue you're running into with the Agent job is that it calls an extended stored procedure. This gives rise…
Answered Apr 24, 2021 · 12 Views Read answer →
SQL Server maintains statistics on substrings in string columns in the form of tries that are usable by the LIKE query. However, its is not usable by the SQL Server CHARINDEX query See the String Summary Statistics section for more about this. A couple of important caveats are that any escaping of wildcards must be…
Answered Apr 24, 2021 · 12 Views Read answer →
No, it isn't dangerous, but it depends on which version of SQL Server you are talking about, what parts you are using (just the DB engine?, SSIS?, SSRS?, ...) and your level of aversion to the small risk. Developer edition is essentially Enterprise edition under a different licence. The problems you could hit are that…
Answered Apr 24, 2021 · 13 Views Read answer →
Learners asking and answering questions on the same topics — follow their questions and join in.
Cyber Security learner
159Questions 203AnswersCyber Security learner
147Questions 179AnswersCyber Security learner
133Questions 158AnswersCyber Security learner
107Questions 142AnswersSalesforce learner
103Questions 162AnswersCyber Security learner
97Questions 141AnswersGuides, tips and career advice on SQL Server from JanBask experts.
SQL Server Top 75 SSAS Interview Questions and Answers For Beginners & Experts
Prepare for your SSAS interview with our comprehensive guide featuring 75 top SQL Server Analysis Services interview questions…
SQL Server How to Become a SQL Database Administrator?
How to become a sql database administrator In 2025, discover what these professionals do, explore how much they earn and learn…
SQL Server OLAP vs OLTP: Key Differences, Architectures, Performance & Real-World Examples
Compare OLTP vs OLAP with clear definitions, architecture diagrams, real-world examples, and FAQs. Learn when to use each system…
SQL Server 70+ Most Asked SSIS Interview Questions for Freshers & Experienced
Prepare for your next SQL Server Integration Services (SSIS) interview with our top 70+ SSIS interview questions and answers.…
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step SQL Server guides from industry experts
Common SQL Server interview questions, answered
