Skip to content
Code Solution
  • Home
  • Technology
    • Android
    • AngularJS
    • ASP.NET
    • Computer Enthusiasts
    • Database Administrators
    • Graphic Design
    • HTML
    • Information Security
    • Laravel
    • Magento
    • MySQL
    • Node.js
    • PHP
    • Python
    • ReactJS
    • Salesforce
    • Ubuntu
    • Unix & Linux
    • Webmasters
    • WordPress
  • Magenaut Blog
  • Game & Software License Key
  • Privacy Policy

Home » json

json

Generate JSON with property names that include dot using SELECT FOR JSON

August 7, 2022 by cs_admin

I need to generate the folowing JSON payload (shortened) from a table in SQL Server. Please note the dot in the property name. This is a special syntax called OData.

Categories Database Administrators, Technology Tags json, sql-server, sql-server-2019, t-sql Leave a comment

Json extract of [‘a’,’b’,’c’]

August 7, 2022 by cs_admin

My json is of the format [“a”,”b”,”c”]. I want to write a sql query such that

Categories Database Administrators, Technology Tags json, mysql Leave a comment

Best way to map different JSON keys to same target columns

August 7, 2022 by cs_admin

I have CSV import data that comes from multiple vendors with 50+ different columns, and each vendor has slightly different naming.

Categories Database Administrators, Technology Tags database-design, json, postgresql, postgresql-9.6, schema Leave a comment

JSON_EXRACT vs native SQL query

August 7, 2022 by cs_admin

I was originally going to ask this on SO, but thought better of it, so I am trying my hand here.

Categories Database Administrators, Technology Tags json, mysql Leave a comment

Unique array values for this string_to_array

August 7, 2022 by cs_admin

This is a follow-up to:

Categories Database Administrators, Technology Tags join, json, postgresql, query, schema Leave a comment

Two OPENJSON, return each array element in separate rows

August 7, 2022 by cs_admin

I have a table where I save in JSON format the quantity that exit and return of a product.
The data saved in the two columns out_quantity and in_quantity is in array format.

Categories Database Administrators, Technology Tags cross-apply, join, json, sql-server Leave a comment

Join variable number of rows in Postgres into json array

August 7, 2022 by cs_admin

I have the following table:

Categories Database Administrators, Technology Tags aggregate, json, postgresql Leave a comment

Importing CSV with a json array of strings in one of the column

August 7, 2022 by cs_admin

The columns of the CSV are of the format text (can include empty lines), date and a JSON array of strings (something like ['a', 'b', 'c']. I’ve been trying to copy that CSV to a PostgreSQL table (using psycopg2‘s copy_expert, which simply executes the given SQL COPY command, if that matters)

Categories Database Administrators, Technology Tags csv, json, postgresql Leave a comment

jsonb_array_elements() fails with “ERROR: cannot extract elements from an object”

August 7, 2022 by cs_admin

Using: Postgres 14.2.
Objective: To get a list of all distinct countries in my table.

Categories Database Administrators, Technology Tags json, jsonb, postgresql Leave a comment

How to sum nested values from a JSON array based on conditions

August 7, 2022 by cs_admin

I have a table with 3 columns in Postgres 14.2: name, name_adds, aditional.

Categories Database Administrators, Technology Tags aggregate, json, postgresql Leave a comment
Post navigation
Older posts
Page1 Page2 … Page150 Next →

Recent Posts

  • Top 5 Programming Languages to Learn for Beginners in 2022!!
  • Why would you ever use asp.net’s ViewState storage object over the Session storage object?
  • Generate JSON with property names that include dot using SELECT FOR JSON
  • insertion in a table of objects with nested table in oracle
  • Compare occurence of chars in PostgreSQL string
  • How to fix unicode REPLACEMENT CHARACTER � in postgres database
  • Junction table or denormalize?
  • Mariadb Benchmarking – Low transaction and query per second
  • SQL Server / SSMS taking up lots of disk space
  • SQL Server: Is it worth checking for change in a field before the update?

Tags

.net adobe-illustrator ajax android angularjs apex asp.net asp.net-mvc authentication bash c# command-line css database eloquent encryption express html java javascript jquery json laravel laravel-4 laravel-5 lightning-web-components linux magento2 marketing-cloud mongodb mysql node.js pandas passwords performance php postgresql python reactjs sql sql-server tls typescript windows windows-7
© 2023 Code Solution • Built with GeneratePress