Browse by Tags
All Tags »
xml (RSS)
As many of my colleagues know, I am not a really big fan of XML. I think it's bloated. I think it's not needed. I don't think it accomplishes much if anything that couldn't be done before just by sending text delimited in a different way...
SERIOUSLY too long of an article name, but hey, it covers a large amount of stuff. I basically had some large XML blobs (wordml docs) I needed to store in SQL and I wanted to store them as compressed BLOBs to save space. These are the articles I found...
This is in response to this article and is me giving dennis a hard time. =P byte [] XmlToByte(XmlDocument d) { using (StringWriter sw = new StringWriter()) { using (XmlTextWriter xw = new XmlTextWriter(sw)) { d.WriteTo(xw) ; ASCIIEncoding encoding = new...
-- create a mini inventory structure -- let's say it has toys in it declare @x xml set @x = '<items> <item id="1" type="toy"> <name>car</name> <description>toy car</description> <price>10<...
passing csv to a stored proc is bad m'kay. it leaves you open to sql injection attacks and in general isn't the best practice anyway. i'm going to avoid entire code samples just because it's too much typing, but let's take a sample proc and assume you...