Productivity Tools

Tools written by an IT business manager, a passionate developer.

Select-SQLView – to be updated

Allows to quickly select view or table from SQL Server.

When first used you need to provide database name and server name.

Select-SQLView -Name me.raport -DatabaseName PawelDT -ServerName .\sql2017

After first invocation database and server name will be stored in the configuration and next time you can call method with providing just table or view name.

Select-SQLView me.raport3

Both commands will execute sql:

SELECT * FROM me.raport

If some additional condition is needed suffix to the command can be added:

Select-SQLView me.raport "where value>1000"

Current configuration can be checked using command

Get-MasterConfiguration -Application Select-SQLView