HammoTime/SimplePSSql

A simple library for executing Sql queries against Microsoft SQL Server.

SimplePSSql

A simple library for executing Sql queries against Microsoft SQL Server.

Install

# Must be run as an administrator.

Updating

# Must be run as an administrator.
Update-SimplePSSql

Usage

Test-SqlConnection

Test-SqlConnection 'Server=LOCALHOST\INSTANCE_01;Trusted_Connection=True;Database=MyDatabase'

Select-SqlScalar

$Query = 'SELECT TOP 1 [Value] FROM [MyDatabase].[dbo].[MyTable] WHERE [MyColumn] = @Parameter'
$ConnectionString = 'Server=LOCALHOST\INSTANCE_01;Trusted_Connection=True;Database=MyDatabase'
$Parameters = { '@Parameter' = 'TestValue' }
Select-SqlScalar $Query $ConnectionString $Parameters

Select-SqlRows

$Query = 'SELECT TOP 1000 * FROM [MyDatabase].[dbo].[MyTable] WHERE [MyColumn] = @Parameter'
$ConnectionString = 'Server=LOCALHOST\INSTANCE_01;Trusted_Connection=True;Database=MyDatabase'
$Parameters = { '@Parameter' = 'TestValue' }
Select-SqlRows $Query $ConnectionString $Parameters

Update-SqlTable

$Query = "UPDATE [MyDatabase].[dbo].[MyTable] SET [MyColumn] = 'New Value' WHERE [MyColumn] = @Parameter"
$ConnectionString = 'Server=LOCALHOST\INSTANCE_01;Trusted_Connection=True;Database=MyDatabase'
$Parameters = { '@Parameter' = 'TestValue' }
$RowsAffected = Update-SqlTable $Query $ConnectionString $Parameters