quote: I have already written hundreds of low level DB staff in C, C++ (using dblib and ODBC) but not in Delphi. and you can't think of using C this time. Well, I think you should use ADO in Delphi. Doesn't speed up things, though, I guess. Are you doing this at regular intervals with […]
2003-08-12
1 reads
Any good references on the nitty gritty differences between #temp tables and variable tables
2003-08-12
This is an easy one... I have had this problem before, and essentially it is because you don't have some kind of unique identifier on the record. You are likely trying to delete a record that has another record identical to it in the table. There are two ways to eliminate this problem: 1) delete […]
2003-08-11
I have run the code in Kashif's answer and if you change pubs to northwind in his code, it works fine. Basically, you had 3 problems: 1) sever 2) pubs 3) no set on the activeconnection
2003-08-08
Frank, Unfortunatly this is not the point. Of cours I can call system command out of Delphi. But what I have to do is programatically send the data to SQLServer (i.e via bcp_sendrow) as I've done in C programmming language. The main problem why your solution is not working is the fact that on my […]
2003-08-08
1 reads
Because of active portions of the log, the process I usually follow is: 1) truncate 2) shrink 3) shrink again 4) shrink... please! 5) SHRINK damn you! 6) ok, this is your last chance... SHRINK!! (mutter under breath) 7) detach db 8) rename LDF file 9) attach db specifying just the MDF (let it create […]
2003-08-05
1 reads
How does the package fail? What errors are reported, if any?
2003-08-01
Thanks a lot. I tried select command but it seems to me that there is a limit using fields in the select command. I am using following syntax. SELECT ' '+CHAR(13)+CHAR(10)+ '*** DOCUMENT BOUNDARY ***' +CHAR(13)+CHAR(10)+ 'FORM=LDUSER'+CHAR(13)+CHAR(10)+ '.USER_ID. |'+'a'+convert(varchar(10),STU.[ID])+CHAR(13)+CHAR(10)+ '.USER_NAME. |'+'a'+LN+','+FN+CHAR(13)+CHAR(10)+ '.USER_LIBRARY. |'+'a'+convert(char(10),STU.SC)+CHAR(13)+CHAR(10)+ '.USER_CATEGORY1. |'+'a'+convert(char(5),STU.GR)+CHAR(13)+CHAR(10)+ '.USER_GROUP_ID. |'+'a'+MST.RM+CHAR(13)+CHAR(10)+ '.USER_ADDR1_BEGIN.'+CHAR(13)+CHAR(10)+ '.STREET. |'+'a'+STU.ST+CHAR(13)+CHAR(10)+ '.CITY/STATE. |'+'a'+STU.CY+','+STU.ST+CHAR(13)+CHAR(10)+ '.ZIP. |'+'a'+STU.ZC+CHAR(13)+CHAR(10)+ '.HOMEPHONE. […]
2003-08-01
1 reads
SELECT 'Name : '+[Name]+CHAR(13)+CHAR(10)+ 'Address : '+Address+CHAR(13)+CHAR(10)+ 'Country : '+Country+CHAR(13)+CHAR(10) FROM tablea
2003-08-01
1 reads
quote: Philip, I took some time and tested your function against DateDiff-DateAdd. CREATE FUNCTION dbo.fnDateOnlyBinary (@Date datetime) returns datetime AS BEGIN RETURN cast(substring(cast(@date as binary(8)),1,4) + 0x00000000 as datetime) END CREATE FUNCTION dbo.fnDateOnly_DateDiff (@Date datetime) returns datetime AS BEGIN RETURN DATEADD(d,DATEDIFF(d,0,@Date),0) END Here were the results on a million dates. --Time: 55 --CPU: 13312 --IO: […]
2003-08-01
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers