in

SQL Server Blogs

Voices from the UK SQL Server Community

JPG COALESCE and optional parameters, execplan 1

Downloads: 2,246 File Size: 14kB
Posted By: tonyrogerson Views: 2,637
Date Added: Wed, May 17 2006

Query plan for this query...

declare @fid int
declare
@mid varchar(20
)
set @fid =
9
set @mid = '102389'

select top 10 *
from
mb_message
where mb_forum_id =
@fid
   and top_parent_mb_message_id = @mid

 

Comments

 

Online Car Insurance Quotes said:

Works for me. Many thanks.
Tue, Apr 17 2007 10:00 AM
 

payday loans said:

This is a good program. Thank's
Tue, Apr 17 2007 6:05 PM
 

debt consolidation loans said:

Hi. I found here really interesting facts! Thanks.
Wed, Apr 25 2007 9:13 PM
Powered by Community Server (Commercial Edition), by Telligent Systems