Shulou(Shulou.com)06/01 Report--

Introduction and Operation of mssql Database

High-performance design, advanced system management, support for local and remote system management and configuration, strong transaction processing, support for symmetric multiprocessing, stored procedures, ODBC, and independent sql language. Sql server provides an outstanding database platform for users with its built-in data replication function, powerful management tools, tight integration with internet and open system structure.

Access for small businesses and small websites, and mssql for medium and large websites

The default port of mssql is 1433. The command to restart the service is services.msc.

Mssql suffix name: .MDF, log file suffix: _ log.ldf

Mssql common database name: sa,master,model, msdb

Query statement: select * from table name

Injection of 2.mssql Database

Judgment sentence: 'error indicates that there is a loophole

Determine version information: and 1 = (select @ @ version)

Report database name: id=1 and 1 = (select db_name ())

Get the table name

Get the column name in the table

Get the data of the table

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.