Creating Datebases and Tables using SQL2000 XML supportgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
I know that you can create a database using Xml IIS support in SQL2000 using the following input: http://127.0.0.1/nw?sql=create+database+sqlmxl&root=ROOT where nw is your virtual dicetory sqlxml is the name of the database
-- this query works fine and it did create a database
My quesition here is can I create some tables against the database I just created above If the answer is yes please tell me how? thanx to all
-- Anonymous, May 21, 2001
http://127.0.0.1/nw?sql=create+table+sqlmxl..NewTable+ (Col1+INT+PRIMARY+KEY)&root=ROOT works. Note that the new table is qualified with the new database name, sqlmxl (sic).
-- Anonymous, May 23, 2001