How to put test data in a SQL Server table

You can use the following template to do this: 

declare @i int =1

while @i < 200 begin

INSERT INTO [dbo].[tst_finances]
           ([fromID],[toID] ,[typeID],[statusID],[sum],[created],[projectID],[factPayed])
           ((SELECT TOP 1 id FROM tst_customers ORDER BY NEWID())
           ,(SELECT TOP 1 id FROM tst_customers ORDER BY NEWID())
           ,(SELECT TOP 1 id FROM tst_finTypes ORDER BY NEWID())
           ,rand()* 100000
           ,dateadd(day, - rand()*5000, getdate())
           ,(SELECT TOP 1 id FROM tst_projects ORDER BY NEWID())
           ,dateadd(day, - rand()*1000, getdate())  )
	set @i = @i + 1


Consider the individual elements. 

1. Paste N lines - make a while cycle and inside insert. 

2. To fill in a value using a foreign key, select a random row from the parent table: 

(SELECT TOP 1 id FROM tst_customers ORDER BY NEWID())

3. Getting a random number from 0 to N:

select rand()* 100000, cast(rand()* 100 as int) 

4. Getting a random date (from 0 to N days ago)

dateadd(day, - rand()*1000, getdate()) 

5. Generating a random line: 

select left(NEWID(),7)

In this simple way, you can quickly add any number of lines to the table.11


SQL-tool for creating personal accounts on the site

The essence of the approach and the history of the creation of Falcon Space
Web platform for creating personal accounts

Falcon Space Platform

This is a reduction in the cost of ownership

at the expense of fewer people to support

This is a quick change

while using the program

This is a modern interface

full adaptation for mobile devices

MS SQL web applications. Affiliate program for developers and web studios

You can develop on your own or collaborate with us on Falcon Space web development using only SQL and HTML.
See examples with SQL code
Platform documentation
Working on MS SQL Server
Component demo stand
At the stand you can see various components in action - tables, forms, modal windows, diagrams, a map, etc.
Solution demo site
Basic solutions that can be flexibly adapted for yourself - change the appearance, business logic and even the structure of the database.
Discuss the project
Ask the initial questions about the project that concern you right now. We will advise you for free and recommend the best solution.