How to run a SQL Server script from the command line

To run the script file

  1. Open a command prompt window.
  2. In the Command Prompt window, type: sqlcmd -S myServer\instanceName -i C:\myScript.sql
  3. Press ENTER.

To save this output to a text file

  1. Open a command prompt window.
  2. In the Command Prompt window, type: sqlcmd -S myServer\instanceName -i C:\myScript.sql -o C:\EmpAdds.txt
  3. Press ENTER.

No output is returned in the Command Prompt window. Instead, the output is sent to the EmpAdds.txt file. You can verify this output by opening the EmpAdds.txt file.

How to download SQL Server Express, the easy way

For some not easy to understand reason, Microsoft has made downloading SQL Server Express very difficult. According to this blog post, you have to go through 12 steps to download SQL Server Express 2014.

Luckily, Scott Hanselman has put togetter a page where you will find all the direct links you’ve always wanted. So here you have the SQL Server Express download page, just 1 click away!

http://downloadsqlserverexpress.com

The 5 Types of Prospects

1. The Most Aware: Your prospect knows your product, and only needs to know “the deal.”

2. Product-Aware: Your prospect knows what you sell, but isn’t sure it’s right for him.

3. Solution-Aware: Your prospect knows the result he wants, but not that your product provides it.

4. Problem-Aware: Your prospect senses he has a problem, but doesn’t know there’s a solution.

5. Completely Unaware: No knowledge of anything except, perhaps, his own identity or opinion.