SQL Bits Mar 2022
SQLBits March 8 - 12 London Excel www.sqlbits.com-
Recent Posts
- Setting up a big query service account.
- Searching for underscores with LIKE
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 3
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 2
- SQL Server and sending messages to Slack. ( or how I stopped worrying about emails) Part 1
Archives
Categories
Meta
Monthly Archives: November 2012
Enforcing XML Document Structure
by default the xml variable supports a content structure of xml this is very useful if you are constructing an xml blob. It works for typed and untyped code, and it has it’s place. The following code shows an xml … Continue reading
Schema visibility using xml_schema_namespace
One of the issues I’ve faced is the constant referencing and rereferencing of XML Schemas that are stored against a database. the xml_schema_namespace dmv helps with this. it takes 2 parameters. the schema of the database object XML Schema and … Continue reading
Posted in SQL, XML, XML Schemas
Leave a comment