Caroline Brown

Should we use TCP or Named Pipes or use the default in SQL server?

Named Pipes protocol are useful for the application that are designed around NetBIOS or other LAN-based protocols. Named Pipes provides easy access to Remote Procedure Calls (RPC) within a single security domain and thus is advantageous to these applications. Usually TCP Protocol is good in practice because you don't…

SQL Server

Answered Jul 12, 2021 · 1.9K Views Read answer →

Missing Return Statement When Implementing the StubProvider Interface

When a method has a non-void return type, you're responsible for ensuring that all code paths are terminated by a return statement. In this case, your switch statement prescribes the return value for a specific set of logic paths, but the compiler can't guarantee that the condition will be true. You need to provide a…

Salesforce

Answered Apr 23, 2021 · 1.7K Views Read answer →

How to display sql server boolean type True & False for 1 & NULL ?

SQL server boolean data type=can be TRUE , FALSE or UNKNOWN . However, the boolean data type is only the result of a boolean expression containing some combination of comparison operators (e.g. = , , < , >= ) or logical operators (e.g. AND , OR , IN , EXISTS ). Alternatively, you can use strings 'true' and 'false',…

SQL Server

Answered Apr 22, 2021 · 5.0K Views Read answer →

How to use SQL server foreach loop?

You can do this in T-SQL, PowerShell is still viable and potentially a lot easier, especially when you leverage dbatools. You can use Get-DbaDatabase to not only get the databases but also easily filter out problematic ones you probably don't want to execute against (system dbs, offline dbs, etc): Get-DbaDatabase…

SQL Server

Answered Apr 20, 2021 · 1.1K Views Read answer →

Invalid initializer type List found for Map

You can create this trigger functionality without writing a single line of code if you just install the Declarative Lookup Rollup Summaries tool and configure the corresponding Lookup Rollup Summary. The closest constructor which would be valid is to use new Map(List). That would look like: Map events = new…

Salesforce

Answered Apr 16, 2021 · 1.8K Views Read answer →

Error Object arrays are not presently upheld by Python. What to do?

The problem you have is that when you are attempting to build your h_matrix array, it finds that its columns don't all have a similar length. The h_column1_formula array contains 10 as length, the others are length 9. So rather than building an array with a numeric data type, it utilizes dtype=object, since that…

Python

Answered Mar 2, 2021 · 869 Views Read answer →

What is the main difference between sandbox org and production in salesforce except data?

The URL of Sandbox and production org will always be different. Sandbox URL(Login Page):- Test.salesforce.comes Production org(Login Page):- login.salesforce.com

Salesforce

Answered May 1, 2020 · 962 Views Read answer →

how to use salesforce

Salesforce's sales platform offers businesses the opportunity to monitor leads, prospects, and maintain a sales-boosting team. The service cloud helps companies to communicate with clients and offer quality customer service by displaying customer engagement and problem-solving. Salesforce lets businesses monitor…

Salesforce

Answered Jan 7, 2020 · 616 Views Read answer →

How to create custom objects and fields in salesforce?

Salesforce

Answered Sep 12, 2019 · 825 Views Read answer →