一
ALTER PROCEDURE [dbo].[Time_Insert]
@ip varchar(50) ,
@RETURN_ID int = 0 OUTPUT
as
begin
insert into WorkTime(UserID,Time)
select UserID ,getdate() from EmployeeInfo as E where E.ip=@ip select @RETURN_ID=UserID from EmployeeInfo as E where E.ip=@ip
return @@ERROR
end
二
ALTER PROCEDURE [dbo].[Time_Select]
@ip varchar(50) ,
@RETURN_ID int = 0 OUTPUT
asbegin
declare @id int
exec @id= Time_Insert @ip,@RETURN_ID output
select * from WorkTime where UserID=@id
return @@error
end
存储过程二能否调到一的执行结果,并正确执行,如不行,应该怎么写啊,谢谢了!
ALTER PROCEDURE [dbo].[Time_Insert]
@ip varchar(50) ,
@RETURN_ID int = 0 OUTPUT
as
begin
insert into WorkTime(UserID,Time)
select UserID ,getdate() from EmployeeInfo as E where E.ip=@ip select @RETURN_ID=UserID from EmployeeInfo as E where E.ip=@ip
return @@ERROR
end
二
ALTER PROCEDURE [dbo].[Time_Select]
@ip varchar(50) ,
@RETURN_ID int = 0 OUTPUT
asbegin
declare @id int
exec @id= Time_Insert @ip,@RETURN_ID output
select * from WorkTime where UserID=@id
return @@error
end
存储过程二能否调到一的执行结果,并正确执行,如不行,应该怎么写啊,谢谢了!
set @order_count = 0
exec @order_count = Time_Insert @ip,@RETURN_ID output
select * from WorkTime where UserID=@order_count
set @id=@RETURN_ID
select * from WorkTime where UserID=@id
还是要用你写的啊
谢谢!
用wufeng4552的应该可以了,谢谢了!