<div>
use top 1 in SQL Server<br />
<br />
select top1 from .....
</div>


<div>
It should be <br />
<br />
select top 1 * from yourtable ....
</div>


<div>
Minor technical note (NO pts of course :) ):<br />
<br />
Technically you should enclose the &quot;1&quot; in parentheses, like so:<br />
<br />
SELECT TOP (1) ...<br />

</div>


<div>
IIRC, that is the newer, and preferred, syntax.
</div>


<div>
But top won't necessarily get yo uthe same record every time, unless you specify an absolute WHERE clause, or use and &quot;order by&quot; statement. &nbsp;Based on the fact that you need top, I'm assuming there where clause won't just return 1 record, so figure out the proper order by and add it. &nbsp;Otherwise, without the order by, there is no guarantee of the order.
</div>


<div>
<div class="content wysiwyg-content">
experts... I have a sybase query like this.<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;select<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;first @RecordStatusID = lm.RecordStatusID<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;From<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;it_systems.ft_ArchivedLoan<wbr />Box alb<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;left join<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;it_systems.ft_ArchivedLoan<wbr /> al<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;on<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(alb.ArchiveID = al.ArchiveID)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;left join<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ezadmin.ft_LoanMaster lm<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;on<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(al.LoanID = lm.LoanID)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;where<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(alb.ArchiveBoxNum) = (@ArchiveBoxNum)<br />
<br />
<br />
What is the equivalent function for &quot;first&quot; in SQL Server 2005/2008??
</div>
</div>


experts... I have a sybase query like this.

	select
		first @RecordStatusID = lm.RecordStatusID
	From
		it_systems.ft_ArchivedLoanBox alb
	left join
		it_systems.ft_ArchivedLoan al
	on
		(alb.ArchiveID = al.ArchiveID)
	left join
		ezadmin.ft_LoanMaster lm
	on
		(al.LoanID = lm.LoanID)
	where
		(alb.ArchiveBoxNum) = (@ArchiveBoxNum)


What is the equivalent function for "first" in SQL Server 2005/2008??

first record in sql server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.