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

* Get-ISData

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.