I have a text file that I must import into a table I created in SQL Server but am having terrible difficulty trying to use the command line BCP utility to do so. Can anyone please tell me how to do this?
Text file and table properties below:
Text File:
1
Untitled
Mark Rothko
Oil
1961...
I have a text file that I must import into a table I created but am having terrible difficulty trying to use the command line BCP utility to do so. Can anyone please tell me how to do this?
Text file and table properties below:
Text File:
1
Untitled
Mark Rothko
Oil
1961
5'9"x4'2"
2
The...
I have a view that returns a subset of contents available to all users within this system. The view works fine and returns the details it needs to. The stored procedure that is used to query the data for a particular user works fine as well. Below is the view that I'm working with.
CREATE...
I have a web application that on launch opens a full-screen browser with some customization (no bars, menu, etc.) - when the users exit the appliation the window is closed. The problem is that IE is retaining the last used window settings and when the user then goes to open just a regular...
Okay, apologies up front for I am not a DBA by any means but I have never had such problems trying to import data in my life, I'm hoping someone here can help me out with this one.
I have an Excel spreadsheet with the following information in each row:
ResponseID, Response1, Response2...
Here's what I'm trying to map the path to.
Server.MapPath("\application\html\")
Here is what is being returned
c:\inetpub\wwwroot\application\html
However, this is not correct. The actual path is:
c:\inetpub\wwwroot\dpsu\application\html
The above is what should be returned...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.