can I have multiple data-types in the parameters of a stored procedure?

is this legal? can I have DATE, INT, and VARCHAR in the params of my procedure?

CREATE PROCEDURE GetDatesInRange(start_date DATE, end_date DATE, eid INT, title VARCHAR)

Open in new window


Thanks.
LVL 25
Kyle HamiltonData ScientistAsked:
Who is Participating?
 
Paul JacksonConnect With a Mentor Software EngineerCommented:
yes that is legal
0
 
Kyle HamiltonData ScientistAuthor Commented:
thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.