Posted by David Portas on 06/11/06 14:36
Baihao Yuan wrote:
> 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
>
http://www.sommarskog.se/share_data.html
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
[Back to original message]
|