Anne Bell

Why does BULK INSERT insert data in random order?

BULK INSERT reads huge chunks of data by default (the file is one batch) and assumes that if the sort property is not set, the order is not needed. If you specify the sort, the bulk file will be sorted and aligned with the clustered index. The rows from the file are read in order, and added to the table in the same…

SQL Server

Answered Apr 16, 2021 · 24 Views Read answer →

How to MERGE a subset of the target table?

The MERGE statement in SQL is a very popular clause that can handle inserts, updates, and deletes all in a single transaction without having to write separate logic for each of these. The MERGE statement tries to compare the source table with the target table based on a key field and then do some of the processing.…

SQL Server

Answered Apr 16, 2021 · 27 Views Read answer →

DECLARE a variable inside function in SQL Server?

For sql server declare table variable, you need to declare a table variable with the same shape as the TVF result, then use INSERT INTO not SELECT INTO, and remember to add brackets/parentheses to the end of the function name when invoking it, i.e. Foo() not just Foo: DECLARE @Table TABLE ( [Id] [int] NULL, [Number]…

SQL Server

Answered Apr 16, 2021 · 188 Views Read answer →

How to rewrite the query to not use CONCAT function in SQL Server 2008 R2?

From SQL Server 2008 R2 version and below the "+" (plus sign) is an operator used in a string expression that concatenates two or more character or binary strings, columns, or a combination of strings and column names into one expression or into another column. You can concatenate strings in SQL Server just by using…

Salesforce

Answered Apr 16, 2021 · 294 Views Read answer →

What are standard and custom fields in salesforce?

Each standard and custom object in salesforce can contain both standard and custom fields as well. The fields in salesforce are like columns of a database table which can hold specific types of data. Every field has a datatype.A data type indicates what kind of information the field stores. Supports a bunch of data…

Salesforce

Answered Dec 1, 2020 · 2.2K Views Read answer →

what is a salesforce developer

A Salesforce developer is responsible for the following: Visualforce basic Platform development Search solutions basics Data modeling, management, and security Developer console Apex object-oriented programming Salesforce object query language Lightning framework

Salesforce

Answered Apr 20, 2020 · 590 Views Read answer →

Create the field called “Contact Relationship” checkbox on the Contact Object and Create the related object called “Contact Relationship” related list to the Contacts.(Look Up Relationship).Now logic…

trigger CreateCRonContactCreation on Contact (after insert,after update) { if(trigger.isAfter) { if(trigger.isInsert) { ContactMasterHandler ConIns = New ContactMasterHandler(); ConIns.createContactRelationshipByContact(trigger.New); } } }

Salesforce

Answered Jan 5, 2020 · 3.2K Views Read answer →

How to define variables in Salesforce Apex?

Salesforce

Answered Nov 30, -0001 · 672 Views Read answer →