python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Why my SQL MERGE inside an EXECUTE BLOCK with doesn't work?
A table1 contains a list of ids. The goal is to check if inside a table3 (for each id from the table1) there is a row which contains this id. If not, I would like to insert a new row which contains a ...
Alek KT
Votes: 0
Answers: 1
Does Firebird have an addition assignment operator?
Does Firebird have an addition assignment (+=) to be used in procedures?
Estevanbs
Votes: 0
Answers: 1
Use a returning value from an INSERT table (A) into another table (B)
I need to use the returning value of the Table A (ID) and insert it in Table B as a parameter:
insert into tableA (ID, Name , Address)
values (GEN_ID(GENERATOR,1),'John','123 street')
returning ID
-...
Tonathiu Redrovan
Votes: 0
Answers: 1
How can I add the date to the filename of an output file with isql (Firebird) using an SQL inputfile?
I currently try to modify an sql script from a colleague as my first steps into SQL.
Basically 2 queries and output into 2 files with a static name work as intended from one sql-script input file.
How...
Fabian Billenkamp
Votes: 0
Answers: 1