Sometimes it is easier to use FOR XML AUTO to retrieve XML from SQL Server than it is to use FOR XML EXPLICIT. However, if you’re combining data from multiple tables you may not get results you expect using the AUTO mode. Suppose that we want to get a list of the products in our database, but we
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help