I want to run “Execute Script” of update or insert statment
I look for indication for the script execute results
From what I saw on the site (variables, log etc), I noticed that there is a reference to the results of SELECT statements only
and not for UPDATE or INSERT.
In addition, Is it possible to run several legal update/insert/delete statment in the same script and see their full log?
From what I’ve tried - if there is an error, Log shows only the reason for thefirst fall of the first sentence and refers to all the rest
update Employee as Emp set Emp.ID = 1 where Emp.ID< 0
I want to see in the log how much rows were updated
My script is:
insert into Employee as Emp (ID, firstN, LastN) values(1, A, b);
Delete From Employee as Emp where Id=1;
I want see for each statment what were the results of execute it on DB.
Thank you for answer