Using SQL datetime and smalldatetime values inside XQuery

(Mike Rorke) I had a request today asking me how to get the current date/time as part of an XQuery expression in SQL Server 2005. The XQuery standard defines various functions to do this type of action, but unfortunately, SQL Server 2005 XQuery does not support these 🙂 Rather, you need to get the d

Read More - Register for Free Membership