[quoted text, click to view]

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
--

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



--

Thanks a lot, I really appreciate it.

Baihao


--