TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Thomas.j.russell
NA
1
0
Stored procedure
Sep 8 2004 12:00 PM
Hi guys, Need some help with some basic stored procedure stuff. i have the following stored procedure. In which I want the procedure to count the number of records that have a status of a in column "REGISTRATION_TYPE". However whenever i test the procedure it asks me to input a value for @value and it does not work. ALTER PROCEDURE dbo.REGISTRATION ( @Value int OUTPUT ) AS SET NOCOUNT ON Select @Value = Count(*) FROM TB_REGISTRATION Where TB_REGISTRATION.REGISTRATION_TYPE = 'A' RETURN Thanks for the help
Reply
Answers (
0
)
Database control
Visual Tools for MS Office System problem