Front page / Stack Overflow · hot matching “sql”

4 shown · updated 4m ago · read only

Why does adding ORDER BY time DESC cause the query to return no data? (stackoverflow.com)stack

28 points by Simon in stackoverflow.com · 1h ago · stack comments

In Apache IoTDB 1.3.7, why does adding ORDER BY time DESC cause the query to return no data? This query returns data: SELECT * FROM root.iot_prod_2.p.cjzxjd.t0020.ori WHERE time >= 1791625620000 AND time < 1791648000000; However, after adding ORDER BY time DESC , no data is retu…
filed under sql apache-iotdb
Getting a timeout error when trying to make a node web server run a stored proc on SQL Server 2022 Express (stackoverflow.com)stack

26 points by FlyRunningHare5 in stackoverflow.com · 5h ago · stack comments

This code works just fine if I try to run a command from powershell to run the stored procedure: sqlcmd.exe -S "MYSERVERNAME\SQLEXPRESS01" -d DB1 -U "User1" -P "Password1" -Q "declare @ReturnValue int declare @ReturnMessage nvarchar(4000) exec spMyStoredProc 'employeeNumber', nu…
filed under node.js sql-server typescript powershell http
How to get instance ID in Wix CLI embedded script? (stackoverflow.com)stack

20 points by Razmik Karapetyan in stackoverflow.com · 9mo ago · stack comments

I have an issue with my Wix CLI project and would appreciate your help. Context: The Wix Dashboard data is passed to and stored in our MySQL database by our PHP backend using the instance ID as a unique identifier for each site. Problem: I have created a custom embedded script u…
filed under velo
How to select multiple columns based on a condition in SQL? (stackoverflow.com)stack

16 points by sundy in stackoverflow.com · 5y ago · stack comments

I have a table, the columns are like this: | id | position | A | B | C | D | E | I'm selecting by id. If the position is '1', it should return column A, B, C. If not, it should return column D, E For example, if the table is: | id | position | A | B | C | D | E | | 0 | 1 | a | b…
filed under mysql sql