The title of the book is also kept in the same table as shown below: The table also contains price and stock count of the books along with an Id for unique identification of books. The staff member (end user of the system) adds information about books belonging to different categories in the table Book. ProblemĪ Bookstore Solution saves information about books in a database object ( table) called Book. We are going to explore the article further just like a real world scenario in which you are given a problem and you have to come up with a solution at your earliest convenience. There are many ways to generate test data including using 3 rd party tools and pre-written test script. We often come accross situations where we need to generate test data. This article can help you to get your hands on a very basic test data generator open for further exploration assuming you have basic know how of SQL. If you have just begun your SQL journey and are keen to get a starter, then this article is a good match for your requirements. The idea behind this article is to develop a basic understanding of generating test data for an object of interest for development testing or solving a problem.Īnother objective of this article is to provide a high-level (basic) view of how test data generators work. In this article, I am going to walk you through the steps of creating test data for a database object such as books in SQL.
#Sample data generator sql server 2012 code#
Download source code (Stored Procedure) - 3 KB.
0 kommentar(er)
