lynnton
asked on
ala_frosty where are you?
To clarify a little ambiguity there .. you actually create the stored procedure on the SQL Server either through the enterprise manager, or query analyzer. You then call that procedure from vb as described.
Create procedure pr_OperatorUnavailable
AS
BEGIN
-- INSERT ALL THE CODE HERE
-- You don't actually need the BEGIN END commands, but I like using them anyway.
END
GO
__________________________
how to create a procedure?
Thanks,
Lynnton
Create procedure pr_OperatorUnavailable
AS
BEGIN
-- INSERT ALL THE CODE HERE
-- You don't actually need the BEGIN END commands, but I like using them anyway.
END
GO
__________________________
how to create a procedure?
Thanks,
Lynnton
q) "how to create a procedure?"
a) Using the method you have described in your question.
a) Using the method you have described in your question.
Here's an example.
create procedure test
( @empno varchar(10)
)
as
select * from employee
where empno=@empno
create procedure test
( @empno varchar(10)
)
as
select * from employee
where empno=@empno
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you already have a set of SQL statements you need to put in a stored procedure ?
What should be the parameters, if any ?