1  
   2      [Microsoft.SqlServer.Server.SqlFunction]
   3      public static SqlString sqlmsh(string input)
   4      {
   5          string output;
   6          Runspace runspace = RunspaceFactory.CreateRunspace();
   7          runspace.Open();
   8          Pipeline pipeline = runspace.CreatePipeline(input);
   9          MshObject myobj =   pipeline.Invoke()[0];
  10          if (myobj.BaseObject is XmlDocument)
  11           {
  12              output = (myobj.BaseObject as XmlDocument).InnerXml;
  13          } else
  14              output = myobj.ImmediateBaseObject.ToString();
  15              
  16          runspace.Close();
  17          return new SqlString(output);
  18      }