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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:51 PM
Points: 550, Visits: 665
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 @ 6:20 PM
Points: 3,622, Visits: 8,127
Use a test environment.


Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:51 PM
Points: 550, Visits: 665
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 @ 6:20 PM
Points: 3,622, Visits: 8,127
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.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:51 PM
Points: 550, Visits: 665
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-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:09 PM
Points: 39,968, Visits: 36,327
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