jormillan
asked on
How do I export data from my tables to a sql file(syntax)?
I have always use Sybase products and there is an excellent feature in ASA/ASE "Save Rows as...", this allow you to save your data in SQL syntax so you can insert rows directly from the file. I have not seen an option where I can directly save my rows in sql syntax. I am relatively new in MS SQL Server can anyone please tell how can I save the rows from my table in sql syntax?
i.e: INSERT INTO balance VALUES ('0099', 2500);
INSERT INTO balance VALUES ('0099', 2520);
INSERT INTO balance VALUES ('0089', 2870);
INSERT INTO balance VALUES ('0087', 4890);
i.e: INSERT INTO balance VALUES ('0099', 2500);
INSERT INTO balance VALUES ('0099', 2520);
INSERT INTO balance VALUES ('0089', 2870);
INSERT INTO balance VALUES ('0087', 4890);
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://vyaskn.tripod.com/code/generate_inserts.txt