SQLite now has CTEs, and the documentation says you can use it with insert, update and delete queries — but only gives examples of select statements. I can figure out how CTEs apply to inserts, via insert-select; but how can we use them in update or delete, where there is no from-clause? Answer CTEs can…
Where can I find SQL language specification [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 11 months ago. Improve this question Is there an official SQL standard? I.e. I want to understand what type…
How to read sql query from a txt-file in Java
I am having some some class that is sending queries to data base. Everything was working fine when the query was in the code, but as it’s pretty big, I decided to put it in a file and to read it with buffered reader, but it’s not working, I always get this: java.sql.SQLException: ORA-00900: invali…
T-SQL split string based on delimiter
I have some data that I would like to split based on a delimiter that may or may not exist. Example data: John/Smith Jane/Doe Steve Bob/Johnson I am using the following code to split this data into …
how to use dynamic query inside a function
i’m trying to create a function GETUSERPROP(prop, filter_prop, filter_value) that selects one item in database filtering by property and value SET @_GET_PROP = “name”; SET @_FILTER_PROP = “id”;…
Why does not Hibernate set @DynamicInsert by default
Could anyone explain to me why Hibernate does not set the @DynamicInsert annotation by default and allow entities to generate an INSERT based on the currently set properties? What’s the reason for not using @DynamicInsert and, therefore, including all entity properties by default? Answer What @jb-nizet …
MySQL: Convert relative seconds count to datetime?
I have a MySQL database show uptime for devices. The uptime is how long the device has been up in seconds. I have a query showing all devices with uptime less than 86400 (24 hours) which I want to …
Incorrect syntax in query
Hello i have this query : It says me that : Incorrect syntax near the keyword “AND” Answer Try this
SQL Geometry find all points in a radius
I am fluent in SQL but new to using the SQL Geometry features. I have what is probably a very basic problem to solve, but I haven’t found any good resources online that explain how to use geometry objects. (Technet is a lousy way to learn new things…) I have a collection of 2d points on a Cartesia…
ConfigurationManager in WPF
I have a config file in a wpf project to store the connectionstring. But when I try to get AppSettings and ConnectionStrings, I get null. the WEB.config file is like this: I tried in several ways: None of them worked. But this one worked: (That means I cannot use a config file, which is against my will) I nee…