Author: Claudio Hira

How do i retrive just 1 row from a sql table

Answer:

found this nice sql-tip for ya:: 

you have 2 options: 

- use TOP function in sql 

-----start 
SELECT TOP 1 * FROM myTable 
-----end 

- by setting the rowcount before selecting in sql 

-----start 
SET ROWCOUNT 1 
SELECT * FROM myTable 
-----end 

Note: If you use SET ROWCOUNT and you have a batch of commands, make sure you SET ROWCOUNT immediately before the SELECT statement. If you SET ROWCOUNT before an UPDATE or DELETE it will limit the number of rows affected by those operations.