{"id":879,"date":"2011-03-28T20:57:40","date_gmt":"2011-03-29T01:57:40","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?page_id=879"},"modified":"2011-03-28T20:58:33","modified_gmt":"2011-03-29T01:58:33","slug":"decoding-sql-grammar-%e2%80%94-insert-statement","status":"publish","type":"page","link":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/decoding-sql-grammar-%e2%80%94-insert-statement\/","title":{"rendered":"Decoding SQL grammar \u2014 insert statement"},"content":{"rendered":"

This demo helps you fully take advantage of the general SQL parser to decode SQL grammar of insert SQL statement.<\/p>\n

Take this SQL for example:<\/p>\n

    \r\ninsert into departments(department_id,department_name,manager_id,location_id)\r\nvalues(70,'Public Relations',100,1900);\r\n<\/pre>\nSQL elements in insert statement decoded by this demo:<\/p>\n\r\ntable: departments\r\ncolumns: \r\n\tdepartment_id\r\n\tdepartment_name\r\n\tmanager_id\r\n\tlocation_id\r\nvalues: \r\n\t70\r\n\t'Public Relations'\r\n\t100\r\n\t1900\r\n<\/pre>\nDownload this demo: C# version<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"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<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":235,"menu_order":120,"comment_status":"closed","ping_status":"open","template":"gsp_feature_page_tt.php","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nHelp you to make better use of General SQL Parser<\/title>\n\n\n\n\n\n\n\n\n\n\n\n