RE: BCP OR BULK INSERT
Can you post, or Private Message me, the 1st few records of your file? May 1st 100 lines or so.Make sure what you post produces a error/problem on your end first.
2004-01-29
C#
RE: Linked servers query problem
If I understand you right, yes. My understanding of severity levels on errors isn't what it should be- I don't know if they error you are getting actually fails the batch/sp. Using string executes I would think it wouldn't matter though. Give it a shot unless someone more knowledgable gives a better solution.. fetch... begin […]
2003-11-21
1 reads
2003-11-21
RE: QOD 21 Nov
Who comes up witht his questions. You guys on the forum are absolutely right. This magazine should come to the forum and post an appology ...and gives us our two points darn it.
2003-11-21
1 reads
RE: HELP!! Installation questions
How can I do this all through enterprise manager? And do you think if My current set up is program files and data/log on D drive - that I need to go through this hassle to make it correct or is it okay to leave as is and just do the seperate drives going forward? […]
2003-11-20
1 reads
RE: Printing Out A dB Schema
Yes I don't have a plotter here, and I need to take the file to a blueprint office to get it printed, I need to know which file(s) I should take that would have the schema in. Thanks CJ
2003-11-19
1 reads
RE: How to import a .sql file with DTS
Replace filename with the name of the .sql file, eg if the file you want to execute is called test.sql in the temp directory of your c: drive then would use isql /S servername /U username /P password -d databasename -b /m-1 /i c:\temp\test.sql Remember to change the other parameters as well.
2003-11-19
1 reads
RE: Using DTS in an off the shelf application
Before you get too heavily tied into using DTS as part of your application, take a look at the following. Hope this helps Phill Carter -------------------- Colt 45 - the original point and click interface
2003-08-28
RE: "Sets" in SQL?
Interesting idea. Article at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=38812 where Itzik Ben-Gan discuss idea of using array sets for performance gains. Basically, use a varbinary(?) as an array to store 4 digit numbers. Still needs a bit of code.
2003-08-26
RE: irregular @@rowcount behavior
That was the intent. I want to tell the user that the record was successfully updated, but it does not seem to happen that way.
2003-08-25
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers