Decoding SQL grammar — insert statement
This demo helps you fully take advantage of the general SQL parser to decode SQL grammar of insert SQL statement.
Take this SQL for example:
insert into departments(department_id,department_name,manager_id,location_id) values(70,'Public Relations',100,1900);
SQL elements in insert statement decoded by this demo:
table: departments columns: department_id department_name manager_id location_id values: 70 'Public Relations' 100 1900
Download this demo: C# version