e.g. for TMSQuery.SQL.Text:
Code: Select all
SELECT [EMPNO]
,[ENAME]
,[JOB]
,[MGR]
,[HIREDATE]
,[SAL]
,[COMM]
,[DEPTNO]
FROM [SDACDemos].[dbo].[emp]
Code: Select all
INSERT INTO [dbo].[emp]
([EMPNO], [], [], [], [], [], [])
VALUES
(:[EMPNO], :[], :[], :[], :[], :[], :[])
SET :[EMPNO] = SCOPE_IDENTITY()
Code: Select all
UPDATE [dbo].[emp]
SET
[EMPNO] = :[EMPNO], [] = :[], [] = :[], [] = :[], [] = :[], [] = :[], [] = :[]
WHERE
[ENAME] = :[Old_ENAME]
Best regards
Ernest