Friday, February 11, 2011

Running SQL Scripts in VIsual Studio 2010

Instructions

Open Visual studio.
Go to the data menu
Choose transact SQL
Then choose new connection
Below is a screenshot of the connection dialog, connecting to sqlexpress



Copy and paste the script into the window. (Links to the scripts can be found on the ITC 222 site.



From the Data Menu select Transact SQL/Run Query. The script will install the database objects and the data into sql server

No comments:

Post a Comment