Database Reference
In-Depth Information
Figure 5.36
Export data with bcp utility.
Figure 5.36 shows that eight rows have been copied to the Employee.txt ile.
3. You can view the ile Employee.txt in Notepad as shown in Figure 5.37. Press the
Windows Icon
key. Click the
File Explorer
icon. Type
notepad
on the address bar
and press the
Enter
key. Open the Employee ile in the folder C:\Program Files (x86)\
Microsoft Visual Studio 11.0.
4. To perform data import, create a table EMPLOYEE_IMPORT in the database
Computer_Store with the same design of the EMPLOYEE table. his can be done
by running an SQL statement on your virtual machine. To do so, open SSMS and
connect to
MYSERVER
with Windows authentication. Right click at the database
Computer_Store
and select
New Query
. Enter the SQL statement as shown in
Figure 5.38 and execute the code.
Figure 5.37
Data exported to text ile by bcp command.
Figure 5.38
Create EMPLOYEE_IMPORT table.