Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #969

Re: Help for XML data type in ms-sqlserver

Show all headers | View raw

thanks for not getting that "disturbing" thing wrong;)

while talking about an invoice, of course we will have some unique
values in the master row. /but document number of an invoice may be a
null or a zero length string also/ but im trying to use this technique
for all master detail record sets. for instance, while saving a "group
list" /we have a just group name for master row, and have some group
details. some distinct groups may have the same group name/ and i have
more than 50 master detail schemas. so this technique may not fail for
dublicate records/
i wrote about a 2 levels document in order to make it simple, but for
instance my real invoice document has 4 levels /invoice master,
invoice rows, invoice row details product list (there may be more than
1 product for an invoice row), invoice rows product list discount
details (there may be unlimited number of discounts for each product
in each rows) etc./

but if i can find a perfect method for 2 levels, developing wont be
problem i think.

to admit, up to now, i was trusting the application code to prevent
invalid data. but now my goal is doing this with sqlserver functions
and removing all the validity controls from the application.

/last week, one of our programmers designed a plugin for our system.
there was a bug and that plugin wrote some invalid rows into orders
and ordersdetails table. thats why i want to move all the saving
procedures into sqlserver/ /after solving this i may also prevent
sqlserver sessions from accepting "INSERT INTO" and "UPDATE"
statements, just accepting "SAVE_XXX_DOCUMENT" functions i decide
here/

we use sqlserver2005 (and 2008 somewhere) now. but may upgrade all db
servers to 2008R2

actually im not locked to xml type for this job. what would your
advice be here? in terms of ease of implementation or working
performance etc.

thank you, regards

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Help for XML data type in ms-sqlserver Ender Karadağ <enkaradag@gmail.com> - 2012-04-09 10:35 -0700
  Re: Help for XML data type in ms-sqlserver Erland Sommarskog <esquel@sommarskog.se> - 2012-04-09 21:22 +0200
    Re: Help for XML data type in ms-sqlserver Ender Karadağ <enkaradag@gmail.com> - 2012-04-09 13:32 -0700
      Re: Help for XML data type in ms-sqlserver Erland Sommarskog <esquel@sommarskog.se> - 2012-04-09 23:31 +0200
        Re: Help for XML data type in ms-sqlserver Ender Karadağ <enkaradag@gmail.com> - 2012-04-09 14:59 -0700
          Re: Help for XML data type in ms-sqlserver Erland Sommarskog <esquel@sommarskog.se> - 2012-04-10 22:14 +0200
            Re: Help for XML data type in ms-sqlserver Ender Karadağ <enkaradag@gmail.com> - 2012-04-10 15:40 -0700
              Re: Help for XML data type in ms-sqlserver Erland Sommarskog <esquel@sommarskog.se> - 2012-04-11 07:34 +0000
                Re: Help for XML data type in ms-sqlserver Ender Karadağ <enkaradag@gmail.com> - 2012-04-19 10:51 -0700

csiph-web