Viewing 15 posts - 31 through 45 (of 86 total)
Beware though. Don't use it without reservation. Excel is not a DB. There plenty of ways to get bit by this by relying on it for production.
January 21, 2009 at 1:05 pm
geetanjaliks (1/20/2009)
January 20, 2009 at 11:56 am
I doubt Ent Manager can do this. Scripting in this case means "Create an SQL Statement to build the table", and that requires knowledge of a bunch of...
January 16, 2009 at 9:42 am
Hate to say it, you've got the wrong tool (Excel) for that job.
It's not designed for concurrent access like that. It has no support for transactions or isolation....
January 15, 2009 at 9:12 am
noeld (1/13/2009)
Any chance to revisit your assumptions and design? any table with 1000 columns sounds rather denormalized to me.
You are being NICE ... any table with 1000 columns...
January 13, 2009 at 12:39 pm
IIRC an nvarchar(max), and the the old text type storage are 16 bytes a field. 1000 columns would roll past that row size too. Storage is 2...
January 13, 2009 at 11:17 am
Is this a text file script you are running? I've seen lots of instances (usually with application installers) where they have a template file, and they either write...
December 18, 2008 at 8:03 am
David (12/16/2008)
As I thought, this is a datetime format issue. My PeopleSoft team says that {fn CURDATE()} is the only way they can perform querys, so...
December 17, 2008 at 9:15 am
MG (12/17/2008)
December 17, 2008 at 8:53 am
Old SQL Newbie (12/16/2008)
I now do a job that didn't exist when I went to school or when I first started work.
Same here. I was a nurse...
December 16, 2008 at 8:39 am
Check the SQL server and be sure you are running on the default port.
December 10, 2008 at 8:31 am
I'd be extremely wary of using MSDAORA in production. It's old, and written against Oracle 7
http://support.microsoft.com/kb/244661/"> http://support.microsoft.com/kb/244661/
It doesn't support all the datatypes, and I...
December 10, 2008 at 8:05 am
Of course, it depends. Remember that if SQL Server does any calculating, casting, joining, etc, you might force the linked server to pull the...
December 5, 2008 at 9:15 am
I assume this to simulate MySQL's ability to use originating host as part of the user identifier? It differentiates me@myhost from me@yourhost. This always struck me as an...
December 4, 2008 at 9:08 am
Sorry, there's way too many ways to look at the request. What do you want to do? Import the data in the sheets to a table? ...
November 20, 2008 at 9:06 am
Viewing 15 posts - 31 through 45 (of 86 total)