服务器:create stored procedure sp_sample @firstpara int ,@secondpara int as
insert into tablename values @firstpara,@secondpara
客户端:
query.close;
Query.SQL.Clear;
Query.SQL.add('insert into tablename(field1,field2) values(:v1,:v2)');
Query.parambyname(':V1').asinteger:=strtoint(edit1.text);
Query.parambyname(':v2').asinteger:=strtoint(edit1.text);
Query.ExecSQL;
服务器:create stored procedure sp_sample @firstpara int ,@secondpara int as
insert into tablename values @firstpara,@secondpara
客户端:
storedprocddure1.prepare;
storedprocedure1.parambyname(@firstpara).asinteger:=strtoint(edit1.text);
storedprocedure1.parambyname(@secondpara).asinteger:=strtoint(edit1.text);
storedprocedure1.open;