Import-Module 'sqlps' -DisableNameChecking


$SV = 'TSTSQL001\MSSQLSERVER1'
$UserID = 'sa'
$Password = 'p@ssw0rd'
$DBName = 'TEST1'


for ($i = 1; $i -lt 300000; $i++) {
    $Query = 'INSERT INTO TEST2 (ID, NAME1, NAME2, NAME3, NAME4, NAME5, NAME6, NAME7) VALUES (' + $i + ', ''NAME' + $i + ''', ''NAME' + $i + ''', ''NAME' + $i + ''', ''NAME' + $i + ''', ''NAME' + $i + ''', ''NAME' + $i + ''', ''NAME' + $i + ''')'
    $ret = Invoke-Sqlcmd -ServerInstance $SV -Database $DBName -Query $Query
}