Asp.NET 4

ali.mohammadi · December 5th, 2010, 04:42 AM

Hi there , As a mater of fact I want to the limitation command(limit) in SQL server.

Thanks a lot.

Imar · December 5th, 2010, 06:49 AM

And your question is what, exactly?

Imar

morteza · December 6th, 2010, 05:34 AM

Hi Imar and Ali
I think Ali want to retrieve limited number of tables record.
If one query return 100 record he want only 20 first record.
I hope this is better explanation .

Imar · December 6th, 2010, 05:41 AM

SELECT TOP 20 ColumnName FROM SomeTable?

Imar

morteza · December 6th, 2010, 05:43 AM

I think it's correct.
Thanks Imar

ali.mohammadi · December 7th, 2010, 08:28 AM

Dear Morteza and Imer;
morteza is right but i want user to select how many rows want to see , it means that do we have any keyword in SQL which gets an integer and shows the same Rows in any kind of Views?

Imar · December 7th, 2010, 08:37 AM

In SQL Server 2005 and later, TOP can be parameterized:

Code:

 
DECLARE @maxRecords INT = 5
SELECT TOP (@maxRecords) * FROM YourTable

returns the first 5 records from the table urTable. To give more meaning to TOP, you may want to add an ORDER BY clause.

Cheers,

Imar