Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > SqlServer中使用参数传递前N条条件

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

WBOY
Release： 2016-06-07 14:54:41
Original
1460 people have browsed it

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
Copy after login
Related labels：
declare sqlserver transfer use parameter condition
source：php.cn
Previous article：Accessa如何在表添加现有字段 Next article：用SQL取到本月为止的今年所有月份
Statement of this Website
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
Latest Articles by Author
Latest Issues
SQL Server: Using CASE WHEN expression with WHERE clause I have a new SpringBoot project with SQLServer and I need to replace the MySQL native quer...
From 2024-04-03 14:46:55
0
1
351
Unable to connect to SQL Server in Laravel I can't connect to sql-server in Laravel. I have given sqlserver configuration values ​​in...
From 2024-03-31 13:08:48
0
1
395
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template