Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dellgx270
Starting Member
6 Posts |
 Posted - 2009-03-11 : 12:57:07
|
| ToyzUnlimited maintains the details of all branded toy products in SQL Server2005 databases and is now using stored procedures for day-to-day have recordsProductCode: varchar(5)Name :varchar(30)Category: varchar(30)Manufacturer: varchar(40)AgeRange: varchar(15)Netweight: int QtyOnHand: int UnitPrice: moneyTask:1.Write statements to create a stored procedure namedSpecificPriceIncrease that will increment the [b]Unitprice of given toys by a given amount.2.Modify the [b]SpecificPriceIncrease stored procedure such that itadditionally returns the number of rows updatedEverybody help me explain. Thanks!Always try for success! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-03-11 : 13:00:10
|
| Why would you write an SP knowing that you want to modify it?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-03-11 : 13:01:09
|
| This looks to be homework. Have you tried something yet? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-11 : 13:12:04
|
| Another one looking for spoon feeded answers! |
|
|
|
dellgx270
Starting Member
6 Posts |
|
|
|
|
|
Stored Procedures