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 |
|
Rahul Raj
Starting Member
41 Posts |
 Posted - 2014-11-11 : 23:06:24
|
| Hi,I am currently working on a stored procedure which will delete records from multi tables. I want to know testing approach of how I can test the same in the DEV environment.Do I need to create all new tables copying the structure and constraints from the original tables or can use the original tables.As the tables are used by other developers as well in the DEV environment thereby I am not sure if any important data is deleted during my unit testing.Can someone share the best approach to do this. |
|
|
sunder.bugatha
Yak Posting Veteran
66 Posts |
Posted - 2014-11-12 : 03:45:44
|
| if the database is small then take a db backup otherwise import the tables into your local machine and start playingHema Sunder |
 |
|
|
|
|
|
Testing for Archival process