Viewing 15 posts - 54,901 through 54,915 (of 59,078 total)
... or ...
"The answer is always 'NO' unless you ask" 😉
September 24, 2007 at 8:28 am
Which property of COLUMN_PROPERTY do you ask for to determine the datatype of a column and how do you use it on a system function like @@ServerName?
September 24, 2007 at 8:21 am
Heh... you mean other than hiring someone who actually "knows" SQL? (Just having a bit of fun, Kenneth 😉 )
There are a couple of dozen articles on this forum about...
September 24, 2007 at 8:15 am
Heh... I was mostly referring to the entire process. For example, If headers are present in the data, they must have the same number of delimiters as the data or...
September 24, 2007 at 8:10 am
YEE-HAH! Now THAT's what I'm talking about... just received the new email response and it's a beautiful thing! They look like this now and it's perfect...
September 24, 2007 at 7:51 am
I'll second that... due to a 3rd party bit of software :alien:, we have hundreds of "usage" databases on one server... they all talk fine with each other with no...
September 24, 2007 at 7:41 am
Heh... If you couldn't tell, I was ticked about this particular problem a wee bit more than the others 😀 Ol' dogs CAN learn new tricks... we're just tired of...
September 24, 2007 at 7:18 am
Muhammad Furqan (22/09/2007)
randomdata;10/10/2007;randomdata;randomdata;
Column1;Column3;Column5;Column4;Column2;
jk adkshfjhjkfhsajkfh sda;sdfs dfasdfsda;fsdaf sadfadsfsda;
dsf;sdf;sdf;sdfds;sdfsd;
So, here is the description.
First line, i dont want it to be in the table, but contains date that i want...
September 23, 2007 at 10:28 am
Sounds a whole lot like interview or homework questions... would have loved to see the reply... "What have YOU tried?" 😀
September 23, 2007 at 10:16 am
...And, BULK INSERT, even with the use of a format file, even beats BCP. That's because BULK INSERT is a wee bit less functional than BCP... for example, BULK INSERT...
September 23, 2007 at 10:09 am
Now... THAT I agree with! 😀
September 23, 2007 at 9:38 am
If you're using windows authentication, then have the domain admins create a windows group for the developers and grant that access to SQL.
Yeah... just not for access to the Production...
September 23, 2007 at 8:59 am
Ya know... I actually get this one... there's been a couple of times that I've had to lookup the datatype for SysName and @@ServerName and the like just because I...
September 23, 2007 at 8:51 am
No... sorry, I can't. I've never had to connect SQL Server to an AS 400...
Lookup "DTS Driver Support for Heterogeneous Data Types" in Books Online... I believe these would be...
September 23, 2007 at 8:41 am
Viewing 15 posts - 54,901 through 54,915 (of 59,078 total)