• Use sp_executesql with an OUTPUT parameter.

    DECLARE @word sysname

    EXEC sp_executesql

    &nbsp&nbsp&nbsp&nbspN'SELECT TOP 1 @DynamicWord = [name] FROM sysobjects'

    &nbsp&nbsp&nbsp&nbsp,N'@DynamicWord sysname OUTPUT'

    &nbsp&nbsp&nbsp&nbsp,@word OUTPUT

    SELECT @word