77 926
Assignments Done
98,3%
Successfully Done
In August 2019

Answer to Question #43156 in Databases | SQL | Oracle | MS Access for Piyush Jain

Question #43156
This is the structure of the table in SQL Azure:

Create Table BCP
(
Id int identity(1,1)
Value int,
Name nvarchar(50),

Constraint [pk_bcp] primMary key clustered([id] asc)
) on [primary]
records I am trying to insert are as follows

100, abc
200, bcd
300, cdf
400, efg
500, fgh
600, ghi
700, hij
800, ijk
900, jkl
I am trying to achieve through command prompt. the command I am using is

C:\Users\Administrator>BCP TestTask.dbo.BCP In C:\Users\Administrator\Desktop\Example\BCP.csv
-S tcp:<servername>.database.windows.net
-U 12345admin@<servername>.database.windows.net
-P Welc@m#123 -E -h 'TABLOCK' -n -k
Expert's answer

Not answered

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions