Not so simple Borislav :-)
I need to select all fields, but I don't know the name of all fields... because it could be any table... my function must be general...
I have already did the following, but I cannot store the result into a field or at least into a variable. How can I do that?
SELECT * FROM inserted FOR XML AUTO
In SQL Help, I found this:
For example, subselect as shown in this example is NOT supported:
DECLARE @doc nchar(3000)
SET @doc = (SELECT * FROM Customers WHERE CustomerID = 'ALFKI' FOR XML RAW)