sql Archives - IT Nursery

Java, Programming

IT Nursery

How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?

I was wondering if there is a more elegant way to do IN() queries with Spring’s JDBCTemplate. Currently I do something like that: ...

June 4, 2022
0 Comments

Programming, sql

IT Nursery

What is the difference between a stored procedure and a view?

I am confused about a few points: What is the difference between a stored procedure and a view? When should I use stored ...

June 4, 2022
0 Comments

Programming, sql

IT Nursery

Concatenate multiple result rows of one column into one, group by another column [duplicate]

This question already has answers here: How to concatenate strings of a string field in a PostgreSQL ‘group by’ query? (14 answers) Closed ...

June 4, 2022
0 Comments

Programming, sql

IT Nursery

Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I ...

June 4, 2022
0 Comments

Programming, sql

IT Nursery

PostgreSQL: Which Datatype should be used for Currency?

Seems like Money type is discouraged as described here My application needs to store currency, which datatype shall I be using? Numeric, Money ...

June 4, 2022
0 Comments

WordPress

IT Nursery

How to display posts of specific category using a custom Query in WordPress?

Hi I want to display a specific category from a custom query in WordPress. My code works fine and it gets the latest ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

Counting null and non-null values in a single query

I have a table create table us ( a number ); Now I have data like: a 1 2 3 4 null null ...

June 3, 2022
0 Comments

WordPress

IT Nursery

register_activation_hook isn’t adding table to DB

I’ve started my first plugin and I need to store values returned from an API call to a database. But before I do ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

Storing money in a decimal column – what precision and scale? [closed]

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the ...

June 3, 2022
0 Comments

WordPress

IT Nursery

How do I add indexes to WordPress Database?

I got a message from Hostgator about my account being suspended because of the load it put on their servers. This is about ...

June 3, 2022
0 Comments