Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I alter this stored procedure to show all people in the stored procedure, even if they don't have a role? ALTER PROCEDURE [dbo].[personSelectAll]

How do I alter this stored procedure to show all people in the stored procedure, even if they don't have a role?

ALTER PROCEDURE [dbo].[personSelectAll] -- Add the parameters for the stored procedure here AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;

-- Insert statements for procedure here SELECT Person.personID, Person.firstName, Person.lastName, Person.email, Person.phone, ValidRole.roleDesc FROM Person INNER JOIN PersonRole ON Person.personID =PersonRole.personID INNER JOIN ValidRole ON PersonRole.roleID = ValidRole.roleID order by lastname, firstname END

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Databases On The Web Learn To Create Web Pages That Interface With Database Engines

Authors: Robert Papaj, Donald Burleson

11th Edition

1576100995, 978-1576100998

More Books

Students also viewed these Databases questions

Question

How might the new SEC pay-ratio disclosure rule help shareholders?

Answered: 1 week ago

Question

Which are non projected Teaching aids in advance learning system?

Answered: 1 week ago

Question

=+ What is the nature of the contracts or agreements with unions?

Answered: 1 week ago

Question

=+What is the procedure for labor relations in the workplace?

Answered: 1 week ago

Question

=+ Are ballots compulsory?

Answered: 1 week ago