Guest_imported
New member
- Jan 1, 1970
- 0
I have a simple stored procedure as shown below.
alter Procedure GetUserInfoDate(@UserName varchar(30),@Udate datetime output)
as
select @UDate = UDate from calendar
where username=@Username
I have 2 parameters, Username which is an input and Udate which is an output parameter.
But when I execute the procedure like
exec GetUserInfoDate "Rebekah"," "
I dont get any output.It just says that the command executed successfully but no result or output is shown.
Any help on this Please!!!
Thx in advance
Rebekah
alter Procedure GetUserInfoDate(@UserName varchar(30),@Udate datetime output)
as
select @UDate = UDate from calendar
where username=@Username
I have 2 parameters, Username which is an input and Udate which is an output parameter.
But when I execute the procedure like
exec GetUserInfoDate "Rebekah"," "
I dont get any output.It just says that the command executed successfully but no result or output is shown.
Any help on this Please!!!
Thx in advance
Rebekah