Retrieving only primary key column numbers from article_tbl and checking against?

Question

Would like to figure out how to better retrieve data from database without performance cost.

Plan as follows:

Select id from article table;
store ids in List<int> arr;
find out last article id. int x = arr.Count()
Select * from article_tbl where id = x; Run query.
Post it on you page.

Am I planning right? What is better way of retrieving data from database?

Thanks a lot

are you just trying to select the latest article and what db are you using ? — Jon Black, Mar 14 '11 at 16:13
Yes it can be solved like "Select top 1 from article_tbl order by date DESC". Thanks mate. But What is better way of retrieving data from database? I am working with SQLServer Express 2008 — user610961, Mar 14 '11 at 16:22

marc_s · Accepted Answer · 2011-03-14T16:23:03.887

Try something like this - you can call it "ad-hoc" or wrap it up in a stored procedure:

-- get the "latest" ID from the "Article" latest
-- but you need to define *latest* by WHAT criteria?? A date?? The ID itself??
DECLARE @LastID INT

SELECT TOP 1 @LastID = ID
FROM dbo.Article
ORDER BY ..........  -- order by date? id? what??

-- get the detail data for that ID from the "Article_tbl"
SELECT (list of columns)
FROM dbo.Article_tbl 
WHERE ID = @LastID

Retrieving only primary key column numbers from article_tbl and checking against?

1 Answers1