Current location - Quotes Website - Collection of slogans - How to add data directly in sql server
How to add data directly in sql server
1. Open heidisql client, create a new connection, connect to the database of sql server, and select the database type. The port number is generally1433; If it is a mysql database, the general port is 3306.

2. After opening the database, select a table to be operated on the left and expand it in turn to open the table to insert data from the database into the table.

3. Click "Data" in the menu bar.

4. Click < b > Insert Data , and a record will be inserted in the record below this location, and data entry will be completed.

SQL Server is a relational database management system. It was originally developed by Microsoft Sybase and Ashton-Tate, and the first OS/2 version was launched in Microsoft SQL Server 1988. After the introduction of Windows NT, Microsoft and Sybase parted ways in the development of SQL Server. Microsoft transplanted SQL Server Windows NT system, focusing on the development and promotion of Windows NT version of SQL Server. Sybase focuses on the application of SQL Server in UNIX operating system.