Viewing 15 posts - 6,211 through 6,225 (of 7,168 total)
Jason Shadonix (6/7/2011)
But would that cause SQL to suddenly feel the need to ship the whole table to the calling server when that field isn't involved in the WHERE clause?
Not...
June 7, 2011 at 9:56 am
VSTS does what you want...quite easily...but it sounds like you miss Oracle 🙂
Good luck!
June 7, 2011 at 9:47 am
SqlCmd is an alternative to BCP that offers a bit more control if you need to output column headers.
June 7, 2011 at 9:42 am
Duplicate post, reply here: http://www.sqlservercentral.com/Forums/Topic1121034-391-1.aspx
June 7, 2011 at 9:40 am
Might as well move to the latest ACE provider:
Sample query:
SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=C:\sample_file.xlsx;',
...
June 7, 2011 at 9:35 am
Visual Studio 2010 Team System (VSTS includes Visual Studio and Team Foundation Server) is Microsoft's CM offering but their approach is a bit different from Oracle's. VS 2010 can take...
June 7, 2011 at 9:24 am
You may be encountering page splits on update now that you have a variable length column in the table.
What is the fill factor setting on your clustered index?
June 7, 2011 at 9:00 am
frfernan (6/7/2011)
June 7, 2011 at 8:38 am
Hmmm...I saw where you could get NULL for specific columns within a returned result set, but cannot figure out how to do what the OP is asking regarding receiving no...
June 7, 2011 at 7:16 am
Ninja's is referring to mysqldump. It can generate a script that contains the schema definitions as well as the data inserts necessary to build the complete database in SQL Server....
June 7, 2011 at 6:51 am
I went looking after your last post and came up empty. Care to share a link?
June 7, 2011 at 6:30 am
yatish.patil (6/6/2011)
I am Thankful to you for your suggestion, But i would like to know if there is any other way to solve the query..i mean there is possibility...
June 7, 2011 at 6:28 am
The article I sent says 2.0 is required...but additional dependencies may exist due to applies SPs and/or patches, etc.
My best advice would be to open a ticket with Microsoft or...
June 7, 2011 at 6:02 am
martin.s.ransome (6/6/2011)
How do I mark this as solved?
It's not really that kind of forum, but in a way you just did 😀
Happy you got what you needed, thanks for...
June 6, 2011 at 6:18 pm
Viewing 15 posts - 6,211 through 6,225 (of 7,168 total)