Powershell in SQL 2008 - playing with ArrayList

By Rajib Bahar at November 25, 2008 13:50
Filed Under: SQL, .NET

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:\>

Tag cloud

Month List