Viewing 12 posts - 736 through 747 (of 747 total)
Could you specify more detail? I don't see the SQLDebugger account in my machine.
December 30, 2005 at 8:00 am
Hi noeld, your sql comes up 22:59:59 which is obviously incorrect.
Slightly change here:
select convert( varchar(8), @d2 - @d1, 8)
SQLBill, your sql also comes out an incorrect answer:2:12:1
This is what I...
December 28, 2005 at 2:15 pm
I am using system sp to get sort of recordset, and then I need to combine this recordset within other select statement. I doubt if I can do this using...
November 2, 2005 at 7:36 am
Hi PW, thanks for sharing your code.
My tool is used to retrieve info from any database, so I can't assume the size of objects, that makes me have to...
September 28, 2005 at 2:09 pm
Thanks for your help. I actually have found a bug of my own code, I am sorry about this posting. Thank you very much.
September 28, 2005 at 1:40 pm
Hi RGR'Us, thank you for your reply, here is my front end code to concatenate the splitted records.
Public Function MergeDataSet(ByVal...
September 28, 2005 at 1:32 pm
I understand there is a 4000 limitation in text column of syscomments, in my script, actually more than one records are returned, which means the script has been splitted to different...
September 28, 2005 at 1:04 pm
I think you didn't notice my requirement: no cursor or temp table is allowed here.
September 27, 2005 at 8:26 pm
While I am sorting this out by doing something external work, I believe there should be a simple and better internal solution.
September 27, 2005 at 2:13 pm
Yes, those docs will still be neccesary for people to download, so they will be stored in database too.
September 2, 2005 at 1:00 pm
Thanks for your quick response.
Do you know what's the scanned and OCRed file type I can get? a word .doc? Then I save this file as an image object into...
September 2, 2005 at 12:13 pm
Thank you guys. I still have question: why the revised query returns incorrect size for nchar and nvarchar? e.g. in Northwind, the CompanyName is nvarcahr(40), this script will return 80,...
August 10, 2005 at 7:26 am