Stored procedure 1:
The ALTER proc [dbo] [hg_deviceno_order]
As
Select * from log_device_list
The set @ "reason='query success! '
Return 0
Stored procedure 2:
The ALTER proc [dbo] [hg_deviceno_order]
As
The update log_device_list set a='2' where a='1'
Insert into log_device_list...
Select * from log_device_list
The set @ "reason='query success! '
Return 0
These two stored procedures, using VB to call first, DataGrid1 can display the result set, the second not stored procedure;
If my first displays, VB call statement there is no problem,
Storage process can't be like the first so simple ah,
If the second I want how to modify it, thank you all for the
CodePudding user response:
You can check the stored procedure execution sometimes there are no mistakes, if there is no error, could not have happened this problem!