search

Home  >  Article  >  Database  >  SqlServer中使用参数传递前N条条件

SqlServer中使用参数传递前N条条件

WBOY
WBOYOriginal
2016-06-07 14:54:411433browse

declare @topN int ; select @topN=10; select top (@topN) * from TableName 一定要用() 否则无效 SQL 参数 declare @topN int; select @topN = 10; select top (@topN) * from TableName

  1. declare @topN int;   
  2. select @topN = 10;   
  3.   
  4. select top (@topN) * from TableName  

    一定要用() 否则无效
SQL 参数 
declare @topN int;   
select @topN = 10;   
  
select top (@topN) * from TableName
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Accessa如何在表添加现有字段Next article：用SQL取到本月为止的今年所有月份

Related articles

See more