ÿþ<html> <head> <title>Test-SqlScript</title> </head> <body> <h1>Test-SqlScript</h1> <div>Determines whether a SQL script is valid.</div> <h2> Syntax </h2> <code>Test-SqlScript [-InputScript] &lt;String&gt; [[-QuotedIdentifierOff]] [[-SqlVersion] &lt;SqlVersion&gt;] [&lt;CommonParameters&gt;]</code> <h2> Detailed Description </h2> <div> The Test-SqlScript cmdlet determines whether all elements of a SQL script are valid. It returns "true" ($true) if all elements are valid and "false" ($false) if any are invalid. Validation errors are returned to stderr. </div> <h2> Related Commands </h2> <div> * <a href='Out-SqlScript.htm'>Out-SqlScript</a><br/> </div> <h2> Parameters </h2> <table border='1'> <tr> <th>Name</th> <th>Description</th> <th>Required?</th> <th>Pipeline Input</th> <th>Default Value</th> </tr> <tr valign='top'> <td>InputScript&nbsp;</td> <td>Specifies a SQL script to be tested.&nbsp;</td> <td>true&nbsp;</td> <td>true (ByValue)&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>QuotedIdentifierOff&nbsp;</td> <td>Specifies whether quoted identifier handling is off&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> </tr> <tr valign='top'> <td>SqlVersion&nbsp;</td> <td>Specifies the Sql version. Valid values are Sql80, Sql90 and Sql100.&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>Sql100&nbsp;</td> </tr> </table> <h2> Input Type </h2> <div>String</div> <h2> Return Values </h2> <div>Boolean</div> <h2> Examples </h2> <h3> EXAMPLE 1</h3> <pre>Test-SqlScript "Select * from authors"</pre> <div>Determines whether the SQL script is valid</div> </body> </html>