This exam tests your abilities needed to establish, design and administrate MS SQL Server 2000, Enterprise Edition. The targeted group of onlookers is competitors with one or more year of interaction administrating and enabling social information base in a medium to vast figuring earth. In different expressions, you may as well be decently acquainted with the SQL social idea before you begin this exam. It could be a difficult time provided that you have no clue what a tables or information bases or records implies! Why take the SQL exam? There is no inquiry that MS SQL Server is tied in the .net planet.

Moreover, in the event that you take a gander at Windows Rights Management System, that shield advanced informative content from unauthorized utilize and insurance of delicate qualified data, for example Web matter, archives, and message, you will observe that it utilized SQL Server as its information base. In different statements, increasingly requisitions will utilize SQL server as its database motor! When you begin the undertaking, check the official MS Exam goal. Utilizing SQL Server 2000 or more forms you can recover information from SQL Server in XML organize straightforwardly from the database. A large number of XML identified offers were consolidated in the SQL Server database.

This prepares the growth of XML empowered requisitions quite basic and it makes trade of information over web basic. In this section we will examine about how to utilize SQLXML to recover information straightforwardly from SQL server database in XML design. There are discretionary parameters in the ‘FOR XML mode’ statement. The XMLDATA alternative includes a XSD composition which portrays the XML design of the outcome reverted. The ELEMENTS choices make the fields of the tables in the database to be turned around as kid components. In the event that the ELEMENTS choice is not there the fields of the tables are reverted as traits as a substitute for little person components of the XML report.

The ELEMENTS choice is permitted just in the AUTO mode. The BINARY BASE64 alternative is utilized to recover any parallel information. The reverted parallel information is turned around in BASE64 encoded organize. The twofold information might be recovered in the RAW or EXPLICIT mode.