Current location - Education and Training Encyclopedia - Education and training - How to create spl database in cadre personnel file management system?
How to create spl database in cadre personnel file management system?
1. Open SQLServerManagementStudio and log in with an administrator account.

2. In the Object Explorer window, right-click the database node and select the New Database option.

3. In the New Database dialog box, enter the database name, select the storage path, select the simple recovery model and other options, and then click OK.

4. In the Object Explorer window, right-click the newly created database and select the New Query option.

5. In the "Query Editor" window, enter the SQL statements CREATETABLEspl(idINTPRIMARYKEY, nameVARCHAR(50), ageINT, sexVARCHAR( 10), departmentVARCHAR(50) and positionVARCHAR(50)SQL to create the spl database.

6. Click the "Execute" button to execute the SQL statement, and you can create a database named "spl" and a data table named "spl".