Commenti

Autore: Dejan SarkaInviato il: 27 ott 2006 - 08.48

Lorenzo,

Thank you for this blog. I have just one remark. I agree with the first weakness of my code you mentioned. However, the second weakness (removing the schema binding) makes no sense. If you remove any constraint from a database, you can insert bad data.

Autore: LorenzoInviato il: 27 ott 2006 - 10.10

Hi Dejan,

> However, the second weakness (removing the schema binding) makes no sense.
I agree, but you have changed the OtherAttributes XML column from schema-validated back to well-formed. :-D

> If you remove any constraint from a database, you can insert bad data.
Exactly, but I don't remove the schema associaton to the XML Column, I simply modify the schema adding the minOccurs and maxOccurs XML Representation Attributes so the constraint remain on the OtherAttributes XML column and the values entered into the column will be validated against the schema.

Autore: ?????? ????? ?????Inviato il: 19 feb 2015 - 13.27

tanks for your website Thanks
<a href="http://www.i-sms.ir">?????? ????? ?????</a>

Autore: tarahi sitInviato il: 11 lug 2015 - 09.52

thanks u.
[url=http://www.portalsaz] tarahi sit[/url]

Autore: tarahi sitInviato il: 11 lug 2015 - 09.53

thanks u.

Autore: Electrical panelInviato il: 29 lug 2015 - 09.40

thank u.

Lorenzo Benaglia

Inside SQL Server 2005: T-SQL Programming

Scrivi un commento

Commenti