[Microsoft.SqlServer.Server.SqlFunction]
public static SqlString sqlmsh(string input)
{
string output;
Runspace runspace = RunspaceFactory.CreateRunspace();
runspace.Open();
Pipeline pipeline = runspace.CreatePipeline(input);
MshObject myobj = pipeline.Invoke()[0];
if (myobj.BaseObject is XmlDocument)
{
output = (myobj.BaseObject as XmlDocument).InnerXml;
} else
output = myobj.ImmediateBaseObject.ToString();
runspace.Close();
return new SqlString(output);
}
You need to create an account or log in to post comments to this site.