As most of us know already, that powershell is the new shell around SQL 2008 to automate database related routines. It reminds me of the manpages in unix itlabs at the UofM. Anyways, I'll start posting few entries related to it. The example below, shows you how to manipulate .NET collection classes.
PS SQLSERVER:\> $c = New-Object "System.Collections.ArrayList"
PS SQLSERVER:\> $c.Add("test")
0
PS SQLSERVER:\>
PS SQLSERVER:\> $c.Add("your")
1
PS SQLSERVER:\>
PS SQLSERVER:\> $c.Add("mind")
2
PS SQLSERVER:\>
PS SQLSERVER:\> $c
test
your
mind
PS SQLSERVER:\>
PS SQLSERVER:\> $c | Select-Object -first 2
test
your
PS SQLSERVER:\> $c | Select-Object -last 2
your
mind
PS SQLSERVER:\>
This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.
Be the first to rate this post
- Currently 0/5 Stars.
- 1
- 2
- 3
- 4
- 5