谷歌傻瓜式SQL注射(Google dorks sql injection)

sql语句查询表的字段名

select name from syscolumns where id in (select id from sysobjects where type = 'u' and name = '相应表名')
用以上sql语句输入相应表名就可以查到表的字段名，对应好数据库查询是否存在该表语句
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tb_cost]') and OBJECTPROPER ......

SQL 大全心雨之家

1.按姓氏笔画排序:
Select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
2.数据库加密:
select encrypt('原始密码')
select pwdencrypt('原始密码')
select pwdcompare('原始密码','加密后密码') = 1--相同；否则不相同 encrypt('原始密码')
select pwdencrypt('原始密码')
select pw ......

SQL查询语句（关于重复数据的）

1、查询表中重复数据。select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2、删除表中多余的重复记录，重复记录是根据� ......

how things work : sql select statement

原网站无法访问，故保留google快照
How things work :
SQL

Select

Statement
Introduction
:
Ever asked your self how things work inside the
SQL

Select
statement? In this article we won’t be talking about how to writeSQL

Select

statem ......

谷歌傻瓜式SQL注射(Google dorks sql injection)

sql语句查询表的字段名

SQL 大全 心雨之家

SQL查询语句（关于重复数据的）

how things work : sql select statement

SQL 大全心雨之家