37,719
社区成员
发帖
与我相关
我的任务
分享
alter PROCEDURE httax_test
@sum nvarchar(16) OUTPUT,
@unino nvarchar(16),
@vendeename nvarchar(20),
@Invoicekind int
AS
insert into HTTAX_SALEBILLVOUCH(unino,vendeename,Invoicekind) values(@unino,@vendeename,@Invoicekind)
select @sum=COUNT(unino) from HTTAX_SALEBILLVOUCH
select * from HTTAX_SALEBILLVOUCH
GO
def save_sql_db():
#pymssql
try:
conn = pymssql.connect(host=SQLSERVER_HOST, user=SQLSERVER_USER, password=SQLSERVER_PASSWORD,
database=SQLSERVER_DATABASE)
cur = conn.cursor()
sql = """ DECLARE @sum int
EXEC httax_test @vendeename='adminstor',@Invoicekind=60,@unino='h019',@sum=@sum OUTPUT """
cur.execute( sql)
conn.commit()
except Exception, e:
print e
else :
return_value = cur.fetchall()
print '>>>>>>>>>>>>>>>>>>>>>>>>> return_value : ',return_value
finally:
try : conn.close()
except : pass