Inoffizielles deutsches Xbase-Forum

Code: Alles auswählen

MERGE mytable a
USING (select f1,f2,f3 from myothertable where blabla) b
ON a.id=b.id
...

Code: Alles auswählen

timestampdiff(SQL_TSI_FRAC_SECOND, cast(curdate() as SQL_TIMESTAMP), now())

Code: Alles auswählen

CREATE FUNCTION temptableexists(@tbname string)
   RETURNS logical
BEGIN
  if exists( select * from 
        (execute procedure sp_getTables(NULL, NULL, NULL , 'Local Temporary')) a
           where table_name like @tbname
        ) then
    return true;
  else
    return false;
  end;