gbdavid2/BasicTopSQLParam.sql

Last active February 19, 2017 20:28

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/gbdavid2/01c92bd8c3b7708aadc8.js"></script>
Save gbdavid2/01c92bd8c3b7708aadc8 to your computer and use it in GitHub Desktop.

Download ZIP

Basic use of a parameter with TOP (Transact-SQL)

Raw

BasicTopSQLParam.sql

	DECLARE @top AS INT = 100

	SELECT TOP (@top) * FROM Sales.SalesOrderHeader

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment