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 |
|
arunatata
Starting Member
2 Posts |
 Posted - 2008-12-08 : 08:04:36
|
| Hi, i want to know about the data mocking in SQL server 2005. When the data is not available based on the join condition, i would like to know how to mock the data in the tables based on the condition .Plz help me out..Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-08 : 08:25:51
|
| mock the data? what do you mean by that? can you illustrate with an example? |
 |
|
|
arunatata
Starting Member
2 Posts |
Posted - 2008-12-09 : 01:32:41
|
| Hi..I am working with database testing using SQL SERVER2005 presently.I get the Stored procedure to run a report. when i see the procedure it contains al the data stuff including Temp tables. When i check the procedure, there will be Join conditions using from different tables of sane database and different databases,holding with temp tables.When the sproc is executed it will be running successfully but it wil not find the data, then we need to mock the data to satisfy the join condition.So i would like to know how to mock the data?hope its clear now. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-09 : 02:03:38
|
| you need to unsderstand how tables are related by looking into join condition and put records with appropriate test values to master and child tables |
|
|
|
|
|
|
Data mocking in sql sever 2005