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: … Read more
sql
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more