![]() First i am inserting data in TUser using ajax post method next in TAddress using another post ajax method and TOrders using another ajax method. One of these things that I re-use in almost every project is the ability to copy and paste data from Excel into a table in SQL Server.Add below script to send data from form to server using ajax.Here,in above form i want to save first 3 fields in TUser table,next 3 fields in TAddress table and final 3 fields in TOrders table. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table.CREATE TRIGGER catalogDB.insertInMultipleDatabases AFTER INSERT ON catalogDB.tableincatalogDB FOR EACH ROW BEGIN DECLARE maxCustId INT DECLARE minCustId INT DECLARE loopCounter INT // For looping. Each customer has the same set of tables which has their own data. ![]() Then, put a comma-separated list of values. The following illustrates the syntax of the INSERT statement: INSERT INTO table (c1,c2.) VALUES (v1,v2.) First, specify the table name and a list of comma-separated columns inside parentheses after the INSERT INTO clause.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |