PHP调用SQL2005存储过程问题
sqlsrv_query($this->conn,"exec up_Ins_tb_User '$user','$pass','$nickname','".(time()+28800)."'")
存储过程:
Create proc up_Ins_tb_User(
@user_name nvarchar(16),
@user_pwd nvarchar(32),
@user_nickname nvarchar(16),
@create_time int
)
as
insert into tb_User([user_name],[user_pwd],[user_nickname],[create_time])values(@user_name,@user_pwd,@user_nickname,@create_time)
insert into tb_Log_Reg values(1,@user_name,@create_time)
在ssms调用这个存储过程是可以用到的,但是在PHP中不行