microsoft sql query syntax

Wednesday, May 19th, 2010

sql query result in XML?
Hi, I have a SQL query that works fine, but do not know how to save it as xml. Can someone please help. Sql = "SELECT ID, name, User XML" I get the following error [Microsoft] [ODBC SQL Server Driver] [SQL Server] Line 1: Incorrect syntax near 'XML'.
This [...]

microsoft sql query builder tool

Friday, May 14th, 2010

Microsoft Community in the Virtual World

microsoft sql server management studio express tutorial

Friday, May 14th, 2010

microsoft sql express

Tuesday, May 11th, 2010

How to import a table as Excel file in Microsoft SQL Server Management Studio Express?
I really need to export only as an excellent table because trying to do it manually just copy and paste is a kind of depth and I have a lot of table to export … Any help would be greatly [...]

microsoft sql express 2008 limitations

Monday, May 10th, 2010

microsoft sql list tables

Sunday, May 9th, 2010

I can How to export a list of all tables and units of Microsoft SQL?

See the metadata. All tables: select * From systables where type = 'U all the dependencies of a table: select * from where depid sysdepends = (select id from sysobjects where type =' U 'and name = 'Customers') all units [...]

microsoft sql versions comparison

Tuesday, May 4th, 2010

Factors DBMS options?
The server is running Microsoft Windows, so now choose Microsoft Access. The current version supports Access and a site for IIS. I wonder if there is a fundamental disadvantage of this system. For example, how the ability to access? What SQL Server, in comparison with the capacity and accessible? In addition, any [...]

microsoft sql getdate

Wednesday, April 28th, 2010

microsoft sql join

Monday, April 26th, 2010

how to become an employee of Microsoft Corp.?
I am ac #. NET developer with 3.5 years of experience, combined with excellent programming skills SQL Server. Please tell the certifications that I have to do to join Microsoft as a developer. Not looking for work-ex relevant group?
You can simply look at the Microsoft [...]

microsoft sql server 2008

Wednesday, April 21st, 2010

which is a better RDBMS, Oracle or Microsoft SQL Server 2008?

SQL Server is clearly positioned between Microsoft Access and Oracle in terms of functionality, performance and scalability. This is a working group at a good solution, a very fast time to market solution, and is very easy to use and administer. Oracle is much [...]