The function of the random insert data should be how to implement? Want to draw a table to specify a list of data, randomly inserted into a separate table specified line specified field, two table completely is not related,

Table 1:
01 A
02 B

Table 2
3 C
4 D

The desired effect (2 rows of 4 columns) :
A C 03 01
02 B D 04

CodePudding user response:

Database? If is SQL server, you can search the NEWID usage, random sequence, two tables with the serial number to associate,

CodePudding user response:

Don't understand your intentions, see?

CodePudding user response:

Describe the error,

See effect is just to get into a new table, contains two tables all fields,