Hi All,
I am trying to insert records into a table as below
INSERT INTO table2 (Emp_ID, Emp_Name, Sal, update_by)
SELECT Emp_ID, Emp_Name, Sal,? FROM table1.
For Updated_By I need some function or wild character that automatically insert Users who is executing the Insert statement.
Kindly advise.