I am trying to resolve this SQL issue where my code throws an error Invalid syntax error near ‘<‘ when I use the variable @totalprice. Without using the variable, the CASE works and the query executes correctly but I want it as a variable Thanks Answer If you want to assign the result of the CA…
Tag: syntax
Calculate Days Between Based on 3 Variables & Syntax Error
I’m hoping you can provide some insights on a couple of issues: ISSUE 1 – i’m receiving the following error message running in Teradata: “Syntax error, expected something like ‘)’ between an integer and the ‘then’ keyword.” There are some duplicate records…
Oracle SQL Select Only 5 Digit Row in a Column [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 1 year ago. Improve this question SLNO Column select only 5 digit row Answer Please use length function of or…
What do the quotes mean in this SQL Server snippet? (SELECT ” column1, ” column 2)
I’d like to know the purpose of the two single quotes in front of each column. This is in a stored procedure. Thank you for your help! Answer The expression ” is an empty string. So this is using an empty string instead of NULL for “missing” values. I would write this code as: This mig…
postgresql: relation “table_name” does not exist when trying to CREATE TABLE
I am running this code thru pgAdmin4: i am keep getting this message: ERROR: relation “supplier” does not exist SQL state: 42P01 The problem is with the foreign key in the product table (1st table), i know this because i removed it and it created all the tables with values (i removed some of the v…
Querying SQL column varchar6 containing numbers with a between statement
The table has a column that is type varchar6 containing 6 numbers between 000000 to 999999, or is empty. No matter what values you give the various variables for this column SEQ, it keeps returning no results but no syntax errors. I suspect you can’t find anything in SQL if you do a between with two var…
Terse syntax to return an empty result set from SQL server
Is there a shorter way to write the following? The “original” question follows. This was was modified may times, explicitly in hopes of stopping Y responses as a result of showing a specific use-case; and [rightly] claimed to be a confusing mess. The use-case is a TSQL query that returns an empty …
INSERT INTO a table comparing two other tables using Not EXISTS
I have 3 tables: Server_db_relation DatabaseList DatabaseList_Archive The goal is to compare table Server_db_relation and DatabaseList based on the values in column ServerName and DatabaseName. If the values do not exists in the table Server_db_relation, but do exist in DatabaseList, then it should insert the…
Why doesn’t Oracle recognize a stored generated column definition?
I have the following generated column defined within a CREATE TABLE statement: ROW_COUNT and PREV_ROW_COUNT are simple NUMBER(18) columns previously defined in the same table. Everything works fine as it’s written. But if I un-comment the STORED option, I get: I need to convert this into a STORED genera…
why does SQL server consider SS as an Umlaut-S (ß)?
When I run the below query: it returns a 6. I specifically chose ß for a function as I thought it very unlikely to appear in any of my data. This was working perfectly fine for several weeks but now all of the sudden it’s detecting ß where there is no ß and therefore screwing up my function. Will someon…