
the day. The following examples are meant to be in DOS or Powershell; and funny, sorry if they aren't funny.
This example is in DOS
sqlcmd -Q "SELECT * FROM [Jokes].[Mom] WHERE type = 'Fat'" -o FatMomJokes.txt
But when you mix Powershell and SQL you can be more productive and creative.
$Jokes = Invoke-Sqlcmd -Query "Select * From [Jokes].[Mom]" ForEach ($joke in $Jokes){ if($joke.Name -eq "your mom"){ Write-Host "$joke.Tell" $script = "Update [Jokes].[Mom] Set Status = 'Told' Where id = $dumb.Id" Invoke-Sqlcmd -Query $script } }
$script = "INSERT INTO [Jokes].[Mom] ([Description],[InsertDateTime]) VALUES ('All night long', '$(Get-Date -Format "yyyy-MM-dd HH:mm:")')" Invoke-Sqlcmd -Query $script -ServerInstance "localhost\sqlexpress"
No comments:
Post a Comment