Posted by Nep Tune on 08/10/06 21:30

It goes like the following:
Use AdventureWorks database and HumanResources.Department table.

Create a stored procedure called spDepartmentAddUpdate. This procedure
accepts two parameters: Name, and GroupName. The data types are
VarChar(50), and VarChar(50) respectively. Define logic in this
procedure to check for an existing Department record with the same Name.
If the department record exists, update the GroupName and ModifiedDate.
Otherwise, insert a new department record.

A. Execute your stored procedure to show that the insert logic works.
B. Execute your stored procedure to show that the update logic works.

Any hints from the wizards out there would be greatly appreciated!

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: ALTER TABLE from sqlcmd script
• Prev in forum: Re: ALTER TABLE from sqlcmd script
• Thread view: Hey I've got a homework problem I'm working on and am stumped.

[Reply to this message]