Can you call a WCF service from an SQL Server 2008 query?

And what would the return d开发者_运维技巧ata look like?

AFAIK, it is possible to call any WS from the stored procedure in MS SQL. It is very similiar to calling Web Services from C# or other .NET language. Here you can find more detailed scenario.