SQL – Page 1536 – SQL Questions Answer

How can I import a JSON file into PostgreSQL?

For example I have a file customers.json which is an array of objects (strictly formed) and it’s pretty plain (without nested objects) like this (what is important: it’s already include ids): And I want to import them all into my postgres db into a table customers. I found some pretty difficult wa…

SQL Server 2012 takes long time on simple alter to add NULL columns

alter-table sql sql-server sql-server-2012 tsql

I have a problem to alter table in SQL Server 2012, it takes a long time to add 04 columns being allowed NULL to large table with 340 columns and approximately 166M rows and 01 non-clustered index This problem happens only specific table after restoring. I’m waiting the execution for 10 hours but it&#82…

Access 2010 Issues with “IS NULL” in Select statement [closed]

ms-access ms-access-2010 sql vba

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers. Closed 5 y…

Show all time stamps for a date in a list box

ms-access sql vba

I have data entered in a table multiple times a day with a date stamp and a time stamp, along with other info. I have 2 fields to filter, primary is day and the other is time. I also have a form with …

how to split gender into two columns as male and female

sql

I have simple table student which contains two column names and gender as m or f. I have to count number of male and female in table and display it into tow different columns . Result should be like: Answer I don’t know m but standard SQL for this would be :

How to Update new tables inside another update query?

mysql php sql

I have a legacy system and i have a php file inside of it, updating one table. Now i added a new table to my db and i want to update that table too. The problem is that (for some reasons) i cannot use another query and i have to change the current query. simplified former query: $q = “UPDATE

One table with many field or two table with fewer fields?

database mysql optimization php sql

My question is simple, currently, I have a database with an “User” table which contains important information about each users (email, username, password), an “Identity” table which contain the first name, last name, birthday… of an user, and a “Medias” table which cu…

Excel VBA SQL from Access no results

excel ms-access sql vba

Using Excel 2010 to query an Access 2010 Database (via UserForms). When I execute the code, I get my Message Box “No Results” (called near the end of the sub). However, there should be 12 records …

Is there a LastIndexOf in SQL Server?

sql sql-server sql-server-2016

I am trying to parse out a value from a string that involves getting the last index of a string. Currently, I am doing a horrible hack that involves reversing a string: To me this code is nearly unreadable. I just upgraded to SQL Server 2016 and I hoping there is a better way. Is there? Answer If you want