May 31, 2006 at 2:57 am
Hi,
I would like to know what is database testing? and how to test the stored procedure??
Regards,
Teja
June 1, 2006 at 3:24 pm
Are you talking about stored procedures you have written or existing ones?
Has a problem popped up or are you trying to provide quality control?
A general rule for testing any program (stored procedure, VB, whatever) is to identify what are the possible interactions with the program, identify the expected results and determine what you can do to make sure all the possible interactions provide the results expected.
Of course, this should not done on a production database (one that is being currently used) but on a copy of the data and stored procedures in a test database to run your tests against.
Does this help?
Steve
June 1, 2006 at 10:25 pm
Thanks steve,
As per my knowledge i know that we need to verify that meets the requirements or not, i would like to know how can we do this at backend using sqlserver query anlayzer or any tool,
please let me update with me the techniques that we follow to test the database.
And how to test the existing storeprocedure(What i know is we will give different sets of data as parameters to test the stored procedure),
will that be ok? or any thing new technique to test the Storedprocedure>
Teja..
June 2, 2006 at 7:25 am
Query Analyzer is an appropriate tool for initial testing of stored proceedures. See Books on Line (BOL) for the correct syntax for EXECUTE. You can pass parameters and check return values (if any).
I would also test with the programming environment that is going to be used to access the data when it is put into production, whether it be a VB app, ASP.NET app, etc.
Steve
June 5, 2006 at 6:06 am
Thanks Steve...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply