The executenonquery method of the sqlcommand class returns an int value of the number of rows affected. You could pipe the results of that command to out-null to eliminate this output. Just add | out-null after the executenonquery command.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Can I Improve this code by using AsJob (Help)? | 0 | 197 | December 31, 2011 | |
| Workflow | 1 | 217 | July 24, 2017 | |
| Powershell script to pull data from AD and make a table | 25 | 389 | November 4, 2016 | |
| Use SQL table and process | 22 | 1167 | April 29, 2024 | |
| My PS Script doesnt throw any errors nor loads data into a flat file | 20 | 447 | December 3, 2020 |