Select NULL from empty XML element in XML variable

An empty element does not have a text(). Try this:

DECLARE @xml xml = N'<t />'
SELECT @xml.value('(t/text())[1]','int');

UPDATE Some explanation

XML uses a defined string format for each datatype. As you surely know, an INT is not stored as a chain of digits, but as a binary value internally. What you see in a resultset and what is generated into an XML is a string representation for human readers following certain rules to ensure correct reading. Date and time values should be ISO8601, BLOBs are converted to base64 and so on...

Each datatype has a default value, with INT this is 0. Try this, it's the same without XML:

SELECT CAST('' AS INT)     --returns 0
      ,CAST(NULL AS INT)   --returns NULL

There is no NULL value in XML (well, you can specify XSINIL to use a marking attribute), but elements can be missing. Only missing elements are read as NULL...

Check this answer for some examples about NULL and empty. Check this answer to understand more about text()

I found also this function:

DECLARE @xml xml = N'<t />'
SELECT @xml.query('/t').value('number(.)','int')

But I was wondering if there is, a way without using inner function. Maybe some namespace.