Creating Datebases and Tables using SQL2000 XML support

greenspun.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

Answers

f**k_be,

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).

Good Luck,

Eric

-- Anonymous, May 23, 2001


Moderation questions? read the FAQ