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

Kyle Hamilton
Kyle Hamilton used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Engineer
Top Expert 2011
Commented:
yes that is legal
Kyle HamiltonData Scientist
Most Valuable Expert 2014

Author

Commented:
thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial