SQL Server 2008中选择一个变量

Question

定义前100名有没有办法选择最前@top通过像在SQL Server 2008中的以下代码的变量定义的价值？

declare @top as integer; 
set @top=100; 

SELECT top @top 
    T1.id as clientInfoId 
    ,T1.ucsId 
    ,T1.phoneHome 
    ... (more columns here)...... 
    ,T1.businessTitle 
FROM 
    YELLOW_OUT_CLIENT_INFO AS T1  
LEFT JOIN 
    YELLOW_OUT_BUSINESS T2 on T2.clientInfoId = T1.id 
WHERE 
    T1.AgentId=5 
    AND 
    T1.deleted IS NULL 
    ... (more conditions here)...... 
ORDER BY NEWID() 

Answer 1

把变量在括号：

SELECT top (@top) 

This functionality was added in SQL Server 2005 ...... 2000是你必须做的SET ROWCOUNT @top