MS SQL Server Related basics

In Java development, the MS SQL Server contact is relatively small, this article records some of the basic knowledge of MS SQL Server.

1. Add an index to the table field: Create INDEX User_openid on user (col1,col2);

Delete indexes: Drop index users_openid on users;

The mysql indexed command is: ALTER TABLE user add index User_openid (OpenID), which is easily confused with SQL Server commands.

2. Win7 Open the Remote connection command:

Start-"Input command line: mstsc--" Enter the IP, username, and password of the remote server you want to connect to

MSTSC parameters:

Input in cmd: mstsc--help

Common parameters are mstsc/admin run as Administrator

MS SQL Server Related basics