SQL statement selecttop variable

Today, when I was writing a stored procedure, I wanted to dynamically extract several rows and start to splice strings. But I always thought it was not good. I checked the information online, I found a method, but it was still unsuccessful. Later I found that this method cannot be used in SQL2000 but can only be used in SQL2005 or later. 1. join query statement (SQL2000

Today, when I was writing a stored procedure, I wanted to dynamically extract several rows and start to splice strings. But I always thought it was not good. I checked the information online, I found a method, but it was still unsuccessful. Later I found that this method cannot be used in SQL2000 but can only be used in SQL2005 or later. 1. join query statement (SQL2000

Today, when I was writing a stored procedure, I wanted to dynamically extract several rows and start to splice strings. But I always thought it was not good. I checked the information online, I found a method, but it was still unsuccessful. Later I found that this method cannot be used in SQL2000 but can only be used in SQL2005 or later.

1. concatenate query statements (SQL2000)

DECLARE @ a AS INT

SET @ a = 1

EXEC ('select top' + @ a + '* FROM mtrcLanguages ')

2. Direct use (applicable to SQL2005 and above)

DECLARE @ a AS INT

SET @ a = 2

Select top (@ a) * FROM Common. tblCode tc