Microsoft® SQL Server 2012 Unleashed

Retrieving an Entry

On occasion, you might need to get a particular entry from a table. When the following code snippet is run, an array is automatically returned:

Click here to view code image

PS SQLSERVER:\SQL\D830\DEFAULT\databases\AdventureWorks2012>  Invoke-SqlCmd "Select * from Person.Person"

PowerShell provides a simple way to look at particular elements within an array. In the following example, entry 100 is returned and then entries 95 to 105:

Click here to view code image

PS SQLSERVER:\SQL\D830\DEFAULT\databases\AdventureWorks2012>  (Invoke-SqlCmd "Select * from Person.Person")[100]PS SQLSERVER:\SQL\D830\DEFAULT\databases\AdventureWorks2012>  (Invoke-SqlCmd "Select * from Person.Person")[95..105]

Note

The first element of an array ...