PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WEBDEV 2024 → Commands in SQL
Commands in SQL
Iniciado por Aarti Yadav, jun., 05 2020 11:09 AM - 2 respostas
#1
Publicado em junho, 05 2020 - 11:09 AM
Hello Everyone, I am new in this community and I want to now about TCL command in SQL, what types of types I can run into it? I want to know about COMMIT, ROLLBACK and SAVEPOINT syntax. Can anyone tell me what's the syntax of these commands?
#2
Membro registado
31 mensagems
Popularité : +1 (1 vote)
Publicado em junho, 05 2020 - 1:07 PM
Hi Aarti,

You may want to check the help on these commands:

HTransactionStart
HTransactionCancel
HTransactionEnd

Hope that helps

Femi
#3
Publicado em junho, 08 2020 - 3:01 PM
Here your answer, How you can use all these three commands:

INSERT INTO class VALUES(5, 'Rahul');

COMMIT;

UPDATE class SET name = 'Abhijit' WHERE id = '5';

SAVEPOINT A;

INSERT INTO class VALUES(6, 'Chris');

SAVEPOINT B;

INSERT INTO class VALUES(7, 'Bravo');

SAVEPOINT C;

SELECT * FROM class;

To know more visit here: https://hackr.io/blog/sql-commands
→ Voltar para WEBDEV 2024