我的存储过程是这样的:
CREATE proc puserid (@username varchar(100), @password varchar(100))
as
Select * from userid
Where Username = @Username
and password = @password
GO我在DELPHI里面是这样写的:
ADOStoredProc1.ProcedureName:='puserid';
ADOStoredProc1.Parameters.ParamValues['@userid']:=Edit1.Text;
ADOStoredProc1.Parameters.ParamValues['@password']:=Edit2.Text;
ADOStoredProc1.ExecProc;它为啥老说找不到@USERID这个参数?
为什么??????
CREATE proc puserid (@username varchar(100), @password varchar(100))
as
Select * from userid
Where Username = @Username
and password = @password
GO我在DELPHI里面是这样写的:
ADOStoredProc1.ProcedureName:='puserid';
ADOStoredProc1.Parameters.ParamValues['@userid']:=Edit1.Text;
ADOStoredProc1.Parameters.ParamValues['@password']:=Edit2.Text;
ADOStoredProc1.ExecProc;它为啥老说找不到@USERID这个参数?
为什么??????
ADOStoredProc1.Parameters.ParamValues['@username']:=Edit1.Text;
ADOStoredProc1.Parameters.ParamValues['@password']:=Edit2.Text;
ADOStoredProc1.ExecProc;
它老说我找不到@USERNAME
表userid :
userid username password
1 1 1
2 2 2
我的存储过程:
CREATE proc puserid (@username varchar(100), @password varchar(100))
as
Select * from userid
Where Username = @Username
and password = @password
GO我的程序:
ADOStoredProc1.ProcedureName:='puserid';
ADOStoredProc1.Parameters.ParamValues['@username']:=Edit1.Text;//这一句都执行不下去
ADOStoredProc1.Parameters.ParamValues['@password']:=Edit2.Text;
ADOStoredProc1.ExecProc;
暂时没得问题了,臭DELPHI
CREATE PROCEDURE ceshi
@table_id varchar(60)
as
if (object_id(@table_id) is not null)
drop table @table_id 在drop table @table_id这行就出错了,不知道为什么,不要说在Delphi中,在SQL的查询分析器中都出错了。
5555555555555555555