I am formalating a query to give the number of reports submitted over the last year ordered by date. I get the current year and month with php: and execute the following query: SQL: And because there has only been 1 submitted in the last year it gives me only 1 result… But I would like the result set to
Sql Command Not Working
I wrote the following code, but nothing is being inserted into the database. I tried changing the SA password in the connection string to something incorrect and the code isn’t catching the exception. What am I doing wrong? Answer As stated by the OP in the comments. Once the try-catch was resolved it w…
How to avoid multiple function evals with the (func()).* syntax in a query?
Context When a function returns a TABLE or a SETOF composite-type, like this one: the results can be accessed by various methods: select * from func(3) will produce these output columns : select func(3) will produce only one output column of ROW type. select (func(3)).* will produce like #1: When the function…
PostgreSQL – dump each table into a different file
I need to extract SQL files from multiple tables of a PostgreSQL database. This is what I’ve come up with so far: However, as you see, all the tables that start with the prefix thr are being exported to a single unified file (db_dump.sql). I have almost 90 tables in total to extract SQL from, so it is a…
How to create/add a column in an SQL select query based on another column’s values?
I want to dynamically add another column hook_name, via an SQL select query, based on a condition. For example if hook_type = 0, table hook_name should have a value of OFFER, and similarly for hook_type = 1, hook_name should show “ACCEPT”. Below is a screenshot of the result: The select query is t…
Find out the nth-highest salary from table
name salary —– —– mohan 500 ram 1000 dinesh 5000 hareesh 6000 mallu 7500 manju 7500 praveen 10000 hari 10000 How would I find the nth-highest salary from the …
How would I write SELECT TOP 25 sql query in Spring data repository
A quick question, because I am sure this is something silly. I have the following query which I can execute in NetBeans sql command window: My goal is to put put it in my ArcustRepository class: public interface ArcustRepository extends JpaRepository { However, that findBytop query doesn’t seem to work …
Stored procedure returns int instead of result set
I have a stored procedure that contains dynamic select. Something like this: In SSMS the stored procedure runs fine and shows result set. In C# using Entity Framework it shows returning an int instead of IEnumerable? Generated function for usp_GetTestRecords Answer Entity Framework can’t tell what your …
How to script out stored procedures to files?
Is there a way that I can find where stored procedures are saved so that I can just copy the files to my desktop?
How do I get the query builder to output its raw SQL query as a string?
Given the following code: I want to get the raw SQL query string that the database query builder above will generate. In this example, it would be SELECT * FROM users. How do I do this? Answer To output to the screen the last queries ran you can use this: I believe the most recent queries will be at the