Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
XCode is an IDE. It's not a database access tool. Do you mean can you use XCode to write software that interacts with MS SQL?
 
Xcode is an IDE. The question as posed doesn't make any sense.

I think what you're asking is does Xcode provide the same hooks (headers, libraries, etc.) that, say Visual Studio does, when writing an application that reads/writes data to a MS SQL Server database. The answer depends in a very big way on what language/API you're using to do this. Raw SQL? Embedded SQL? PHP? Perl DBI? Java?
 
Unless MS-SQL is very special then yes, I see no reason why not. OSX provides an ODBC datasource system. You'll need an MS-SQL driver for it. I'm not sure there is one available, I'd suggest Google.

Or you could go the pure Java route which would work just as well...
 
If you were really stuck, you could check sourceforge and see if there's a freeTDS port for Mac.

** Edit ** - The FreeTDS project does support all BSD based OS's including Mac OS.

http://sourceforge.net/projects/freetds/

A quick google check shows a couple of 3rd party vendors with ODBC drivers.

You could possible use Sybase's Mac OS Client to connect, not sure what that entails though. The db-lib client should still work, although you may have to settle with reduced functionality over the connection.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.