Exporting Registry Keys
Created 09 February 2004 00:00, updated 17 June 2017 10:51
For example, to export all keys under the ASP.NET software section to a file called "test.txt", run the following command:
SQL Server : Inserting Rows Using INSERT...SELECT
Created 13 February 2004 00:00
To copy all the data from one table into another:
INSERT INTO Destination
   SELECT Col1, Col2, Col3
   FROM Source
   WHERE Col1 = 'example'

To copy a table and all it's data (not including primary keys, indexes, etc.):

SELECT * INTO Destination FROM Source
SQL Server : Invoking COM Components
Created 16 February 2004 00:00

You can create and use COM components with the sp_O stored procedures.

sp_OACreate "MyComponent.Class"
would be used to create an instance of your component - you can then use the other stored procedures to fire methods, set properties, etc.
XSL strings : checking string length
Created 18 February 2004 00:00
Example 1: Checking string length

    <xsl:when test="string-length(@sec) >= 12">
      <xsl:value-of select="substring(@sec,0,12)"/>...
      <xsl:value-of select="@sec"/>
MSXSL : Calling script functions
Created 23 February 2004 00:00
  <msxsl:script implements-prefix="portal" language="vbscript">
      Function GetSomething(node)
        GetSomething = Mid(node.item(0).text,12)
      End Function


  <xsl:template match="@MY_FIELD">
    <xsl:value-of select="portal:GetSomething(.)"></xsl:value-of>

You can also do tests against function results. For example, you pass in a value "user_privileges" to your stylesheet. Below, you can then run if tests against your function for blocks within your templates.

  <xsl:stylesheet version="1.0" 

  <xsl:param name="user_privileges" />

  <msxsl:script language="C#" implements-prefix="yours">
    public bool checkPrivileges(string required, string privileges){
      if (required == privileges) {
        return true;
      return false;


  <xsl:template match="your_node">
    <xsl:if test="yours:checkPrivileges(@privileges, $user_privileges) = 'true'">