SQL Server record (updating ...)

SQL Server record (updating...) sys. databases

Show all database information

Sys. tables

Displays information about all tables in the current database.

Go

Sends a batch of signals to the SQL Server utility that the Transact-SQL statement has ended, Go itself is not a T-SQL statement

Sq_addrole, etc.

The SQL Server system stored procedure starts with the character sp.

EXEC or EXECUTE

Execute a command string or string in a Transact-SQL batch process or execute one of the following modules: System stored procedures, user-defined stored procedures, CLR stored procedures, scalar value user-defined functions, or extended stored procedures.

N 'XXX' used in sqlserver'

The N 'XXX' Mark forcibly converts the xxx character in single quotes to a Unicode character, without garbled characters in Chinese.

Because ASCII code (one character occupies one byte) is commonly used in English ), however, the Chinese character we use occupies two bytes, so we need to forcibly convert the N 'xXx' To a Unicode character. in this way, both English characters and Chinese characters occupy two bytes in single quotes, unified, no garbled characters! Plus N indicates that the database is stored in Unicode format.

EXEC sp_helpuser 'username'

View all roles assigned to a specified user. If no user name is specified later, the roles of the users used are listed.

Separated identifiers (database engine)

For more information, see me.