Posted by Baihao Yuan on 06/11/06 13:40

Hi,

I got another question here:

I want to use query like this:

SELECT * FROM (sp_lock AS T) WHERE objectID = ...

The purpose is that I want to query the result set returned by sp_lock
using derived table, but it doesn't work. Why?

Thanks,
Baihao



--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

• Next in forum: Re: use result set returned by sp as derived table
• Prev in forum: Re: Create XML in ASP.NET 2.0 then use for joined table in SQL Server 2005 Stored Procedure
• Thread view: use result set returned by sp as derived table

[Reply to this message]