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