MS SQL Import Txt File

Posted on By David Kittell
sqlcmd -i nonMemLoad.txt -o sqllog.txt

Reference: http://msdn.microsoft.com/en-us/library/ms170572.aspx

Originally Posted on October 15, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL Windows Batch

Related Posts

Max Length Of Data In Column

Posted on

Get Max Length Of Column SELECT max(length(<col>)) FROM <TABLE>; SELECT max(len(<col>)) FROM <TABLE>; Originally Posted on November 1, 2013Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it…

Read More

PowerShell – Show File Extensions

Posted on

function ShowFileExtensions() { # http://superuser.com/questions/666891/script-to-set-hide-file-extensions Push-Location Set-Location HKCU:\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced Set-ItemProperty . HideFileExt "0" Pop-Location Stop-Process -processName: Explorer -force # This will restart the Explorer service to make this work. } ShowFileExtensions function HideFileExtensions() { # http://superuser.com/questions/666891/script-to-set-hide-file-extensions Push-Location Set-Location HKCU:\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced Set-ItemProperty . HideFileExt "1" Pop-Location Stop-Process -processName: Explorer -force # This will…

Read More

SMTP Mail

Posted on

MailMessage m = new MailMessage(); SmtpClient sc = new SmtpClient(); m.From = new MailAddress("email@email.com", "Name Of Person"); m.To.Add(new MailAddress("email@email.com", "Name Of Person")); m.CC.Add(new MailAddress("email@email.com", "Name Of Person")); m.Subject = "Email Subject"; m.Body = sResultsHTML; AlternateView av = AlternateView.CreateAlternateViewFromString(sResultsHTML, null, MediaTypeNames.Text.Html); m.AlternateViews.Add(av); sc.Port = 25; sc.Host = "mail.email.com"; // Email server…

Read More