sql导出EXCEL语句语法错误！

[q826609971]

declare @k int
declare @m int
declare @n int
set @k=2
set @m=(@k-1)*10
set @n=@k*10
EXEC master..xp_cmdshell 'bcp "select * from tempdb..temptable where id>@m and id<=@n" queryout d:test.xls -c -q -S"leiyf" -U"sa" -P"sa"'


语法错误提示：
SQLState = 42000, NativeError = 137
Error = [Microsoft][SQL Native Client][SQL Server]必须声明标量变量 "@m"。
SQLState = 42000, NativeError = 8180
Error = [Microsoft][SQL Native Client][SQL Server]未能准备语句。
NULL

怎么改正！谢谢！！

[發糞塗牆]

@m 和@n引号少了

[jia_guijun]

declare @k int
declare @m int
declare @n int
declare @cmd varchar(200)
set @k=2
set @m=(@k-1)*10
set @n=@k*10
set @cmd='bcp "select * from tempdb..temptable where id>'+cast(@m as varchar(20))+' and id<='+cast(@n as varchar(20))+'" queryout d:test.xls -c -q -S"leiyf" -U"sa" -P"sa"'

EXEC master..xp_cmdshell @cmd

[汤姆克鲁斯]

declare @k int
declare @m int
declare @n int  
DECLARE @sql varchar(max)
set @k=2
set @m=(@k-1)*10
set @n=@k*10
SET @sql='EXEC master..xp_cmdshell ''bcp "select * from tempdb..temptable where id>'+LTRIM(@m)+' and id<='+LTRIM(@n)+'" queryout d:test.xls -c -q -S"leiyf" -U"sa" -P"sa"'''
EXEC(@sql)