ÿþ<html> <head> <title>Set-SqlData</title> </head> <body> <h1>Set-SqlData</h1> <div>Executes a query that does not return a result set.</div> <h2> Syntax </h2> <code>Set-SqlData [[-sqlserver] &lt;Object&gt;] [-dbname] &lt;String&gt; [-qry] &lt;String&gt; [&lt;CommonParameters&gt;]</code> <h2> Detailed Description </h2> <div> The Set-SqlData function executes a query that does not return a result set. </div> <h2> Related Commands </h2> <div> * <a href='Set-SqlData.htm'>Set-SqlData</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>sqlserver&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>dbname&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>qry&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> </table> <h2> Input Type </h2> <div>None You cannot pipe objects to Set-SqlData</div> <h2> Return Values </h2> <div>None Set-SqlData does not produce any output.</div> <h2> Examples </h2> <h3> EXAMPLE 1</h3> <pre>Set-SqlData "Z002\sql2K8" "pubs" "Update authors set au_lname = 'Brown' WHERE au_lname = 'White'"</pre> <div>This command executes the specified SQL query using Windows authentication.</div> <h3> EXAMPLE 2</h3> <pre>$server = Set-SqlServer "Z002\sql2K8" "sa" "Passw0rd" Set-SqlData $server "pubs" "Update authors set au_lname = 'Brown' WHERE au_lname = 'White'"</pre> <div>This command executes the specified SQL query using SQL authentication.</div> </body> </html>