Æ´½ÓSQLÓï¾äµÄÎÊÌâ

SQL code:

declare @topCount int
select @topCount=10

declare @sql nvarchar(400)

set @sql=N'select top @topCount * from tb_company'
exec sp_executesql @sql





Incorrect syntax near '@topCount'.

Õâ¸öÎÊÌâÒªÔõô½â¾ö

---

Êä³ö²ÎÊýÐÎʽ
ÓÃSP_EXECUTESQLÖ´ÐÐ

---

SQL code:
declare @topCount int
select @topCount=10

declare @sql nvarchar(400)

set @sql=N'select top '+@topCount+' * from tb_company'
exec sp_executesql @sql

---

ÒýÓÃ

Êä³ö²ÎÊýÐÎʽ
ÓÃSP_EXECUTESQLÖ´ÐÐ

Ū´í

---

SQL code:
declare @topCount int
select @topCount=10

declare @sql nvarchar(400)

set @sql='select top '+@topCount+' * from tb_company'
exec (@sql)

---

SQL code:
set @sql=N'select top '+@topCount+' * from tb_company'

---

ÒýÓÃ

SQL codedeclare@topCountintselect@topCount=10declare@sqlnvarchar(400)set@sql=N'select top +ltrim(@topCount)+'*from tb_compa