Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SP Expand / Collapse
Author
Message
Posted Monday, March 31, 2014 1:01 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 7:42 PM
Points: 435, Visits: 436
Hi,

I have a sp. I alter stored procedure by adding some logic to that. How can I test that is there any functional impact by altering that stored procedure? How to prove to the team that the modifications doesn't impact any functionality?

Thanks
Post #1556657
Posted Monday, March 31, 2014 1:42 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:17 PM
Points: 3,312, Visits: 7,143
Use a test environment.


Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1556680
Posted Monday, March 31, 2014 2:43 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 7:42 PM
Points: 435, Visits: 436
Hi Luis,

Thanks for the reply. Yes, I can do it in the test env but let me know what kind of tests we have to do?
Post #1556717
Posted Monday, March 31, 2014 2:47 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:17 PM
Points: 3,312, Visits: 7,143
I can't give more advice on this, unless you post more details. I don't know what kind of modifications you did or what are the change policies on your company.


Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1556720
Posted Monday, March 31, 2014 3:49 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 7:42 PM
Points: 435, Visits: 436
Hi Luis,
I have a parent stored procedure which is executing the child stored procedure without any condition. Before calling the child sp, I want to put the check that If the data is available in that variable then only execute that child sp.

I have a parent sp name saveproduct_QP

and it is calling savepricing_QP

for that child sp, they assign some table valued parameters
exec savepricing_QP
@productdetails = @productdetails
@Orderdetails = @orderdetails
@customerId = @customerid output

In the sp I added that
Alter saveproduct_QP
IF EXISTS (SELECT 1 FROM @ProductDetails)
begin
exec savepricing_QP
End

Now, I want to test sp that it doesn't have any functional changes
Post #1556752
Posted Tuesday, April 1, 2014 2:16 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 42,432, Visits: 35,486
So run the original, run the changed and make sure that behaviours are the same. Basic unit testing.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1556836
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse