Viewing 15 posts - 6,406 through 6,420 (of 7,168 total)
Wow, Informix, ODBC 2.0, PHP...say hi to Fred Flintstone for me 😀
SSIS (it's really .NET under the covers) is going to make those calls to the driver asking for metadata...
May 18, 2011 at 12:01 pm
Be careful in choosing an identity column over the solution that is in place. There is a major difference which is that identity can introduce gaps.
Is there a requirement that...
May 18, 2011 at 10:54 am
When working with Unicode columns in SQL Server you have to prefix your literals with a capital N to let SQL Server know your literal is also Unicode.
Try it...
May 18, 2011 at 10:46 am
opc.three (5/17/2011)
ooops...
Sorry for the earlier ooops-post, I posted an incomplete thought and was getting pulled away so just wiped it.
I was going to point out that you can also add...
May 18, 2011 at 10:27 am
david.wright-948385 (1/27/2011)
wouldn't
declare @result varchar(max);
select @result = coalesce(@result + ',' + value,value) from @codes;
select @result;
be a lot simpler?
I agree your T-SQL solution is simpler than the example code used to...
May 17, 2011 at 7:43 pm
These CLR aggregates are inspired by the MSDN code sample however they perform much better and allow for sorting (as strings) and alternate delimiters if needed:
May 17, 2011 at 7:23 pm
Just throwing mud at the wall here...
You may have Excel 2007 installed however I see you're using a .xls extension which is typical for Excel 2003 and before. Try using...
May 17, 2011 at 6:03 pm
I only mean to say that working through a Linked Server to design your MySQL queries when you don't have the full complement of tools available to discover table and...
May 17, 2011 at 4:28 pm
I think we're losing some traction...do you have the MySQL command-line client on your machine? It might be easier for you to log into the MySQL instance directly, build your...
May 17, 2011 at 4:20 pm
sandeep1188 (5/17/2011)
select * from [SORs$A13:M]
I want to import more than 100,000 rows but openrowset stops at 65523 rows when I try to import data from excel by specifying...
May 17, 2011 at 4:01 pm
What is the defined collation on the column you're searching?
Can you please provide the table definition, some sample data and any queries you have tried so far?
If you have doubts...
May 17, 2011 at 3:53 pm
You can try retrieving the column names from INFORMATION_SCHEMA like this:
EXEC ('SELECT TABLE_SCHEMA,
TABLE_NAME,
COLUMN_NAME
FROM...
May 17, 2011 at 3:41 pm
Both provided solutions look good but I'll go ahead and pile on a third option since I spent the time messing with it 😀
IF OBJECT_ID(N'tempdb..#dates_and_times') > 0
...
May 17, 2011 at 3:37 pm
It's possible that SQL Server is trying to use INFORMATION_SCHEMA on the MySQL to expand the * to an explicit column list under the covers and it's failing due to...
May 17, 2011 at 2:59 pm
When your network admin logged in and ran the package manually on the server did he log in as himself or using the proxy account?
Being that its a third-party component...
May 17, 2011 at 2:32 pm
Viewing 15 posts - 6,406 through 6,420 (of 7,168 total)