Viewing 15 posts - 1 through 15 (of 29 total)
I have not researched this possibility yet, but what about upgrading to SQL2005 64bit? What advantages or disadvantages would there be?
January 23, 2007 at 10:41 am
We will be running SQL2000 and I would like to run Win2003 64bit. I would like to run 8GB, but doesn't that require the Enterprise edition of Windows?
January 23, 2007 at 8:49 am
Excel 2003 and SQL 2000 with latest patches. Here's the code...
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="D:\www\BICCS\SalesForce_ContactReport.xls";
User ID=Admin;Password=;Extended properties=Excel .0')...SalesForce_ContactReport
August 4, 2005 at 10:55 am
Ok, now I'm getting this error...
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB...
August 4, 2005 at 10:48 am
Will this be just as fast as if I spread the data out into 1000 character chunks into seperate records?
April 29, 2005 at 6:52 am
Well, I WAS born stupid. It ended up being an ID10T error. The variable wasn't being set correctly.
Sorry for the false alarm
April 5, 2005 at 10:57 am
Nice article, but it doesn't really help me with my problem. Other than the suggestion to build a SQL Statement in a string and execute it. Is that what you...
April 5, 2005 at 9:22 am
quote:
Could you use SET @stName = REPLACE( @stName, ' ', '' ) ?Guarddata
Darn you and...
August 20, 2003 at 3:03 pm
quote:
Works like a charm, thanks!
Thanks! This is my first time making suggestions on this...
August 20, 2003 at 12:50 pm
Here's a simple one. It will only remove one space, but it will work for mulptiple spaces if you run it multiple times.
declare @strName varchar(100)
select @strName = 'St James'
select...
August 20, 2003 at 12:28 pm
Viewing 15 posts - 1 through 15 (of 29 total)