Why doesn't the SQL query work?

Manager1221ByManager1221

Hello, can someone help me?

Basic idea:

Search all columns in a table for a word (without specifying the columns directly). Use hexadecimal for uniqueness. I'm running the query in SQLer Mkll version 2.5.6 and Arc32.

My query is as follows:

 DECLARE @SearchWord NVARCHAR(55) = '0x4f'; SELECT t.name AS Tabellenname, c.name AS Spaltenname FROM sys.tables t JOIN sys.columns c ON t.object_id = c.object_id WHERE t.name = 'kundenadresse' AND EXISTS ( SELECT 1 FROM kundenadresse WHERE CAST(c.name AS NVARCHAR(MAX)) LIKE '%' + @SearchWord + '%' );

Now comes the error:

poQuery: Error 7200: AQE Error: State = 42000; NativeError = 2115; [SAP][Advantage SQL Engine]Expected lexical element not found: expecting <;> or <,> but found <=> — Location of error in the SQL statement is: 34

It seems like he doesn't understand that.

Has anyone found another solution or an error in the query?

Thank you in advance!

(1 votes)
Loading...

Similar Posts

Flexbox – Inspect Mode what is that in WordPress Theme?

ByZweirad2

Hello everyone, I'm currently stuck. I've installed a WordPress theme and want to customize the layout using CSS. Now I'm seeing a flexbox, which is divided into two sections, as shown in this image: And I want to center the headline in the container. However, I can't align it, and I don't know how this…

javascript error, wtf?

ByWeissBrot965

In my 5 years as a js dev I've never had an error like this. Code: <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>fire-base</title> </head> <body> <input id="name" placeholder="name"> <input id="password" placeholder="password"> <button id="login" onclick="save()">login</button> <script> var name = document.getElementById("name") var password = document.getElementById("password") function save() { alert(name.value, password.value) } </script>…

Create your own political semicircle? Which programming language(s)?

BySiad123677

I am very interested in politics and especially in seat allocation and coalitions. I've been trying to make a semicircle like this for ages – see picture (here Austria as an example). I've already tried it with HTML and CSS, but failed with the form and how to connect everything (code and website). Does anyone…

Why isn't my wake word working?

Bymarcus09421

Hello, I'm currently programming a voice assistant and am working on the wake word. My code looks like this: import openai import pyttsx3 import re import pyjokes import speech_recognition as sr from pyowm import OWM import spotipy from spotipy.oauth2 import SpotifyOAuth import time import random import datetime import pytz from geopy.geocoders import Nominatim from timezonefinder…

Subscribe
Notify of
5 Answers
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
GrayCoder
GrayCoder
1 year ago

The error you get occurs because you use the comparison operator LIKE in combination with the = operator in the WHERE clause. SQL interprets the = sign in line CAST(c.name AS NVARCHAR(MAX) LIKE ‘%’ + @SearchWord + ‘%’ as an attempt to use a condition as =, and this leads to a syntax error.

DECLARE @SearchWord NVARCHAR(55) = '0x4f';


SELECT
  t.name AS Tabellenname,
  c.name AS Spaltenname
FROM
  sys.tables t
JOIN
  sys.columns c ON t.object_id = c.object_id
WHERE
  t.name = 'kundenadresse'
AND EXISTS (
  SELECT 1
  FROM
    kundenadresse
  WHERE CHARINDEX(@SearchWord, CONVERT(NVARCHAR(MAX), c.name, 1)) > 0
);
0
Manager1221
Author
Manager1221
1 year ago
Reply to  GrayCoder

Now the error code continues. Can it be all =, because something is wrong in position 34 again? I tried once: As soon as I take the = away in the Declare, he mugs around or gives a new error message, that is to say it is the = there. What can I do or try? Thank you for your previous answer!

0
Manager1221
Author
Manager1221
1 year ago
Reply to  Manager1221

Great.

1
Manager1221
Author
Manager1221
1 year ago
Reply to  GrayCoder

Think the problem has just been solved. Now he’s picking up at the bottom of the Where Charindex:

SQL1 (DD Remote 12.0) Error:

AdsQuery1: Error 7200: AQE Error: State = 42000; NativeError = 2115; [SAP][Advantage SQL Engine]Expected lexical element not found: — Missing table name. There was a problem parsing the table names after the FROM keyword. There was a problem parsing the WHERE clause. — Location of error in the SQL statement is: 259 (line: 16 column: 5)

0
elmex7
elmex7
1 year ago

I don’t think you can explain the variable.

Alternatives: https://www.sqlshack.com/sql-variables-basics-and-usage/

0