Services Common Yes Yes Yes Yes Yes Yes Yes Language Runtime (CLR) Integration Native XML Yes Yes Yes Yes Yes Yes Yes support XML indexing Yes Yes Yes Yes Yes Yes Yes MERGE & Yes Yes Yes Yes Yes Yes Yes UPSERT Capabilities FILESTREAM Yes Yes Yes Yes Yes Yes Yes support FileTable Yes Yes Yes Yes Yes Yes Yes Date and Time Yes Yes Yes Yes Yes Yes Yes datatypes Yes Yes Yes Yes Yes Yes Yes support Full-text and Yes Yes Yes Yes Yes semantic search Specification of Yes Yes Yes Yes Yes language in query Service Broker Yes Yes Yes No No No No (messaging) (Client (Client (Client only) only) only) only) Web services Yes Yes Yes Yes (HTTP/SOAP endpoints)
Services Common Language Runtime (CLR) Integration Yes Yes Yes Yes Yes Yes Yes Native XML support Yes Yes Yes Yes Yes Yes Yes XML indexing Yes Yes Yes Yes Yes Yes Yes MERGE & UPSERT Capabilities Yes Yes Yes Yes Yes Yes Yes FILESTREAM support Yes Yes Yes Yes Yes Yes Yes FileTable Yes Yes Yes Yes Yes Yes Yes Date and Time datatypes Yes Yes Yes Yes Yes Yes Yes support Yes Yes Yes Yes Yes Yes Yes Full-text and semantic search Yes Yes Yes Yes Yes Specification of language in query Yes Yes Yes Yes Yes Service Broker (messaging) Yes Yes Yes No only) No (Client only) No (Client only) No (Client only) Web services (HTTP/SOAP endpoints) Yes Yes Yes Yes
VERSIONS%20n%20EDITIONS%20Compare.docx