Questions tagged [ansi-sql-92]
35 questions
1
vote
1 answer
SWITCH function doesn't work in access sql
With the code below, I'm trying to update table K_tables. The column ColumnType doesn't have zero or null values in it, but after I run this script I get a lot of null valued rows, and the number of rows with certain values (such as BIGINT) is…
Rocketq
- 5,423
- 23
- 75
- 126
1
vote
2 answers
Is N'some string here' ANSI SQL?
We know that in order to qualify a string literal as Unicode, we need to prefix it with N in Transact-SQL. My question is if this is part any standard such as ANSI SQL. Will other database platforms understand this?
UPDATE:
My practical experiments…
Dejan
- 9,150
- 8
- 69
- 117
1
vote
0 answers
Execute sql 92 query on message queue
I want to retrieve messages sent in a queue between two PutTime. I try with this query:
TextMessage vMessage = (TextMessage)
super.receiveSelected("Root.MQMD.PutDate = '"+pPutDate+"'
AND Root.MQMD.PutTime BETWEEN CAST('103345' AS TIME)…
Gorgui Ndong
- 153
- 1
- 10
1
vote
2 answers
Oracle Left outer join
SELECT
a,
last_note_user,
c,
d,
iso_src
FROM
X
CROSS JOIN Y
CROSS JOIN Z
LEFT OUTER JOIN W
ON W.last_note_user = Z.userid
AND W.user_ten = Y.iso_src
The above ANSI code fetch me 107…
kunj
0
votes
1 answer
SQL Auto assign a number to duplicating values that resets after a change in the values WITHOUT using ROW_NUMBER or Partition BY?
I would like to create a "count" or "order" field that would auto-increment, but restart after every change in a different field? In the table below, the "Order" field would restart at "1" every time there was a change in the "Meal" field.…
luanstat
- 65
- 1
- 9