Get-ISData
Gets data from a SQL Server.
Syntax
Get-ISData [-serverName] <String> [-databaseName] <String> [-query] <String> [<CommonParameters>]
Detailed Description
The Get-ISData function gets data a SQL Server.
Related Commands
Parameters
Name |
Description |
Required? |
Pipeline Input |
Default Value |
serverName |
|
true |
false |
|
databaseName |
|
true |
false |
|
query |
|
true |
false |
|
Input Type
None
You cannot pipe objects to Get-ISData.
Return Values
System.Data.DataRow
Get-ISData returns a System.Data.DataRow object.
Examples
EXAMPLE 1
get-isdata 'Z002\SQL2K8' pubs 'select * from authors'
This command executes a SQL query against the pubs database on the Z002\SQL2K8 server and returns the authors table.