python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - powershell-2.0

Script to sequentially move 5,000 files at a time?

I created 1 million files that I'm trying to upload to a device. However, file explorer crashes if I select too many at once. I'm trying to break them up and move them into subfolders in batches of 50...
test-img

stefmf

linux

windows

powershell

powershell-2.0

Votes: 0

Answers: 0

A positional parameter cannot be found in powershell

I have this basic script that import a csv file into sql server database but I'm not sure why I'm getting this error. Import-Csv : A positional parameter cannot be found that accepts argument '+'. At ...
test-img

ziico

sql-server

powershell

csv

powershell-2.0

Votes: 0

Answers: 0

value can not be null error in PowerShell

I'm trying to import my csv file into my sql database using like this but I'm not sure why it's saying Exception calling "ExecuteWithResults" with "1" argument(s): "Value cann...
test-img

ziico

sql

sql-server

powershell

csv

powershell-2.0

Votes: 0

Answers: 1

Latest Answer

Don't remove the column headers, but double check how they are written.. with spaces Your code ignores those here $($_.HoldValue) --> $($_.'Hold Value') $($_.MultMID) --> $($_.'Mult MID') $($_.E...
test-img

Theo

How to query SQL Server using PowerShell

I have this code that I got from a website and it's connected to my SQL Server using window authentication but I'm not sure how can I choose a database and query some table?. [Reflection.Assembly]::Lo...
test-img

ziico

sql

sql-server

powershell

powershell-2.0

Votes: 0

Answers: 1

Latest Answer

For SMO like you have in your question, you can run queries that return data using ExecuteWithResults() like so: $s = New-Object Microsoft.SqlServer.Management.Smo.Server "server instance" ...
test-img

Cpt.Whale

Posts

Questions

Blogs

Jobs