Hacking MSSQL without knowing the password
Copyright owned by original author0x01 Preface
In a recent penetration test, I accidentally noticed some unencrypted MSSQL traffic during packet capture. Because the syntax is put there, it won't be wrong.
Php to read mssql time display format solution. We know that mssql does not use time as php does. the generated time format DateTime is incorrect, the following code is used to copy the code while ($ rowsqlsrv_fetch_array we know that mssql does not
Comparison between MYSQL and MSSQL and MYSQLMSSQL
Recently, I was modifying the MSSQL statements related to a company's product to statements that can be executed on MYSQL.
L Advantage Analysis:
MYSQL is short, easy to use, easy to use, and free
We know that mssql does not use time as php does. The generated time format DateTime is incorrect, as shown below:
The Code is as follows:
Copy code
While ($ row = sqlsrv_fetch_array ($ result, SQLSRV_FETCH_ASSOC )){Print_r ($
Php cannot delete records in mssql. php cannot delete records in mssql.
The table structure in mssql is as follows:
Because hr_id is a string in the uniqueidentifier format generated by mssql, I cannot use php to read this string. it is a
The code is as follows
Copy Code
while ($row = Sqlsrv_fetch_array ($result, SQLSRV_FETCH_ASSOC)){Print_r ($row [' datetime ']);//This field is a time format for MSSQL}The result isDateTime Object([Date] => 2011-10-20
Mssql converts mysql methods. For more information, see.
Mssql converts mysql methods. For more information, see.
Method 1:
1. Table Structure
Use MySQL to generate the create script. Find the script to be exported and modify the Column
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.