Anisha Dalal

What is the process of writing select results to a csv file?

For SQL server export to CSV, you can use the BCP utility BCP "SELECT Col1,Col2,Col3 FROM MyDatabase.dbo.MyTable" query out "D:MyTable.CSV" -c -t , -S SERVERNAME -T The -c argument specifies character output, as opposed to SQL's native binary format; this defaults to tab-separated values, but -t, changes the field…

SQL Server

Answered Apr 24, 2021 · 437 Views Read answer →

Can I install SQL Server Management Studio locally? If yes then how?

To install SQL Server Management Studio 2012 On current versions of Windows, on the Start page, type SSMS, and then click Microsoft SQL Server Management Studio. When using older versions of Windows, on the Start menu, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Management Studio.…

SQL Server

Answered Apr 24, 2021 · 668 Views Read answer →

How to use an External id in salesforce workbench upsert?

The auto number field can not be mapped, you're trying to map by an auto number field, which is read-only, so the mapping logic doesn't support what you're trying to do. This would work if you were working with a mappable field, such as custom External Id on cases, or a required name field (e.g. Account Name).…

Salesforce

Answered Apr 24, 2021 · 1.2K Views Read answer →

Is using a user fake agent illegal?

It is not illegal here in the US. I would be wary of seeking legal advice on the internet, especially without giving a specific location. Laws change city to city as they do country to country. So declaring user fake agent illegal doesn’t make sense unless you state the specific state or city.

SQL Server

Answered Apr 23, 2021 · 0 Views Read answer →

someone received a text from me that I didn't send. There is definitely a virus involved. If so, who has it, the sender or the receiver?

There are two possible scenarios: There is a virus on the sender's phone, or the SMS was spoofed, as per the SMS Spoofing link in your post. According to my understanding, the most likely scenario is that the virus must be in your phone that WebRoot is not able to detect. A good way to check is to ask some of your…

SQL Server

Answered Apr 23, 2021 · 462 Views Read answer →

How to manually link existing records for Salesforce-to-Salesforce?

My Salesforce-to-Salesforce set up and working (with automatic sharing etc). It works great for go-forward records. and struggling to find out how to deal with existing records that exist in both orgs. As an example, if I spin up 2 brand new Dev orgs and connect them with Salesforce-to-Salesforce, I end up with…

Salesforce

Answered Apr 23, 2021 · 574 Views Read answer →

How to deserialize JSON with escaped double quotes?

This is valid JSON. { "errors": [ { "params": { "password": "size must be between 4 and 30", "loginId": "must match "^[a-zA-Z0-9_]*$"" } } ] } This is not: String str = '{ "errors": [ { "params": { "password": "size must be between 4 and 30", "loginId": "must match "^[a-zA-Z0-9_]*$"" } } ] }'; Why? Because in Apex,…

Salesforce

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

hy should I remove the wlwmanifest.xml file in WordPress?

There's no point in removing the wlwmanifest.xml file in WordPress. It's a static file with information on how Windows Live Writer can talk to WordPress Discovering that you're running WordPress is usually rather trivial, so nothing much is revealed by wlwmanifest.xml file either.When it comes to securing WP, focus on…

SQL Server

Answered Apr 22, 2021 · 611 Views Read answer →

Which one is safer - Google Password Manager vs LastPass?

Justin's point was the same as your observation that even LastPass passwords would be 100% vulnerable to malware present on your machine. Your machine is where the ultimate security lies. The Elliot Kember post claims that your overall safety of the password is increased if you require a master password to view other…

SQL Server

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

Is there any built-in function/stored procedure/query which is helpful to retrieve sql server table size in the SQL Server database?

You can determine sql server table size for single table using sp_spaceused MyTable For all tables in a database you can use it with sp_msforeachtable as follwoing CREATE TABLE #temp ( table_name sysname , row_count INT, reserved_size VARCHAR(50), data_size VARCHAR(50), index_size VARCHAR(50), unused_size VARCHAR(50))…

Salesforce

Answered Apr 22, 2021 · 504 Views Read answer →

why refused to display in a frame because it set ‘X-Frame-Options' to 'sameorigin'?

You cannot display a part of websites inside an iFrame. Reason being that they send an "X-Frame-Options: SAMEORIGIN" response header. This option prevents the browser from displaying iFrames that are not hosted on the same domain as the parent page. This is a security feature to prevent click-jacking. "Enable…

Salesforce

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

What is the best way to get salesforce security token of a API Only user?

From Salesfoce Security token and the API (my emphasis): Users can obtain their security token by changing their password or resetting their security token via the Salesforce user interface. When a user changes their password or resets their security token, Salesforce sends a new security token to the email address on…

Salesforce

Answered Apr 22, 2021 · 850 Views Read answer →