Question
Create a function called fn_VendorAddress that gets a VendorName passed in, and returns a Varchar out. [Vendors table] The function should return the full address
Create a function called fn_VendorAddress that gets a VendorName passed in, and returns a Varchar out. [Vendors table]
The function should return the full address of the vendor as a return parameter. The full address should be VendorAddress1, VendorAddress2 (if it has a value), VendorCity, VendorState, VendorZipCode:
So PO Box 96621, Washington DC, 20090 for VendorName: National Information Data CTR.
Create a script that tests your function with Vendors that have a value for VendorAddress2 and Vendor's that don't have a value for VendorAddress2
Step by Step Solution
3.38 Rating (154 Votes )
There are 3 Steps involved in it
Step: 1
Heres a sample SQL function named fnVendorAddress that retrieves the full address of a vendor based ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Accounting Information Systems
Authors: Ulric J. Gelinas, Richard B. Dull
10th edition
9781305176218, 113393594X, 1305176219, 978-1133935940
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App