Parse XML to table
A stored procedure that will parse (shred) the contents of any well-formed XML document into a SQL table.
2015-04-08 (first published: 2013-07-09)
4,982 reads
nodes
Parsing HTML to SQL using SQLDOM
It is simple to parse HTML directly to SQL, manipulate, and render back to HTML using SQLDOM
2019-07-15 (first published: 2012-04-16)
17,451 reads
Adding a Node to a SQL Server 2005 Failover Cluster
Setting up multi-node clustered SQL instances from scratch is common practice for companies that want to implement high availability, but adding a new node to an existing clustered SQL instance that has been running for a while may have a few sticking points, especially for a SQL 2005 instance.
2011-10-12
2,577 reads
RE: Access and Triggers
As you probably have already determined, MSAccess only provides events for Forms and Controls. If your AutoNumber (aka Identity) field is incrementing, not random, then after you insert the record, query for the max value of your identity field.select max(identity_field) from your_table
2004-02-16
RE: T-SQL Bug
Thanks for the tip about dragging the columns, it's a nice one. I have however resolved the bug problem by using exec('insert into tableA select * from tableB'). It worked just as expected. Many thanks to you all for your help.
2003-12-06
RE: Set schedule/start/stop permissions on Jobs
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-12-02
RE: pages clustered/non-clustered index
With a clustered index, the data is at the leaf level of the index, so the index and the datapages are one in the same. The index is not a separate object as with a non-clustered index.
2003-08-26
1 reads
RE: Public Access to System tables
The apps running on the server are written in house. Why do public require select access to system tables ? For some tables ok, there may be a need. But for public to have access to tables sysusers, sysobjects etc etc it seems a bit crazy...
2003-08-19
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers