Viewing 15 posts - 39,166 through 39,180 (of 39,456 total)
The MS site uses XML, but stores this as flat files for much of the data. The flat files are just transformed as the pages are requested. I'd recommend this...
October 24, 2001 at 9:48 am
October 24, 2001 at 9:45 am
You might be able to modify this to just display the items (or scrip them):
Steve Jones
October 24, 2001 at 9:45 am
Do they appear in the Object Browser in Query analyzer? Sorry, but I'm reaching here. not sure of the problem. Have you refreshed your table list in EM?
Steve Jones
October 24, 2001 at 9:42 am
October 23, 2001 at 2:38 pm
October 23, 2001 at 2:37 pm
October 22, 2001 at 11:18 pm
Yes, even poorly written apps will benefit from the enhancements to the storage and query engines. If you have a poorly designed app with lots of embedded sql, the server...
October 22, 2001 at 10:55 pm
The probklem is your last line. This is returning a value, not removing the last ,.
Is should read:
select @r = substring( ...
Steve Jones
October 22, 2001 at 3:48 pm
October 22, 2001 at 2:21 pm
You would do well to script the database DDL and then ensure it conforms to Oracle standards. Not sure, but I doubt the DTS tools will generate Oracle compliant statements.
For...
October 22, 2001 at 2:19 pm
October 22, 2001 at 2:17 pm
I concur with Andy. You probably want to avoid this. You are assuming you know more than the program for a particular statement, which may not be true for different...
October 22, 2001 at 2:05 pm
You would need some column in your table that has a datetime field. Or join to a table that has some date time field. There is no marking in SQL...
October 22, 2001 at 11:53 am
Any solution is going to through a load somewhere. I assume this is a one time thing. I wouldn't worry about the source load. Personally, I'd rather move the entire...
October 22, 2001 at 11:50 am
Viewing 15 posts - 39,166 through 39,180 (of 39,456 total)