Issue: How to Generate Sample Data online for SQL Server Table SQL Server Tutorial 2021.
In this article, we are going to learn How to Generate Sample Data online for SQL Server Table, this is a very common scenario and people always ask for the sample data for doing a different kinds of practices, so just to let you guys know that I am not an advertiser of this web site which I am going to show you in the demo, there could be more websites for generation sample data.
Open your browser and go to www.generatedata.com, it will open a window where you have to provide the information as you required in the sample data, in my case I am selecting the options as follows, 1. ID , then data type 2. Fname, the data type is names, 3. Lname, the data type is names, 4. Sale date, Data type is a date, then next option is rows, you can only generate 100 rows maximum, then select Generate in-page and click on generate.
Fig-1: Sample data generation website page
Once the data will be generated we will select all, and copy that data, as you can see in the picture below we have sample data in in-page format.
Fig-2: Generated sample data in in-page format.
Once data will be copied open you SQL Server management studio, go to your database in which you want to insert sample data, and select a new query, and paste the copied data there, and execute, as we can see in the picture below our execution is completed and it has 100 rows inserted.
No comments:
Post a Comment