导出文本传递参数

[wenlsky]

从数据库中的table1导出到文本,参数@username2怎么传递(这是在存储过程中)
declare @username2 varchar(200)
set @username2='8000000'

EXEC master..xp_cmdshell 'bcp "select * from table1 where username=@username2

" queryout d:\khkf/khkf/duanxin/up/tall.txt -c -S 192.168.1.25 -U sa -P pass

[wenlsky]

感恩以上两位,现以解决

[zlp321002]

--try
declare @username2 varchar(200)
set @username2='8000000'

exec('EXEC master..xp_cmdshell ''bcp "select * from table1 where username='''''+@username2+'''''
" queryout d:\khkf/khkf/duanxin/up/tall.txt -c -S 192.168.1.25 -U sa -P pass
'' ')

[wgsasd311]

declare @username2 varchar(200),@sql varchar(8000)
set @username2='8000000'

set @sql='EXEC master..xp_cmdshell '+
'''bcp "select * from table1 where username='+@username2+
'" queryout "d:\khkf/khkf/duanxin/up/tall.txt" -c -S"192.168.1.25" -U"sa" -P"pass"'''
--print @sql
exec(@sql)