1.首先创建存储过程
create proc testReturn @tid int output as begin set @tid = (select testid from Mytest where testname=@tname) return end
2.写shell调用存储过程
AAA="sql -U 用户名 -P 密码 -H IP:端口 -S 服务名"
logname="XXX.log"
$AAA >> $XXX.log << !
declare @tid int output
exec testReturn @tid output
select @tid
go
!