SQL随机查询
SQL Server：
Select TOP N * from TABLE Order By NewID()
Select TOP N * from TABLE Order By NewID()
NewID()函数将创建一个 uniqueidentifier 类型的唯一值。上面的语句实现效果是从Table中随机读取N条记录。
Access：
Select TOP N * from TABLE Order By Rnd(ID)
Select TOP N * from TABLE Order By Rnd(ID)
Rnd(ID) 其中的ID是自动编号字段，可以利用其他任何数值来完成，比如用姓名字段(UserName)
Select TOP N * from TABLE Order BY Rnd(Len(UserName))
Select TOP N * from TABLE Order BY Rnd(Len(UserName))
MySql：
Select * from TABLE Order By Rand() Limit 10
Select * from TABLE Order By Rand() Limit 10
postgreSQL：
select * from glxt022 order by random() limit 5
select * from glxt022 order by random() limit 5
相关文档：
sql server 2008 bcp 批量复制程序 出错
C:\Documents and Settings>bcp MSPetShop4.dbo.product out c:\1.txt -T
SQLState = 08001, NativeError = -1
Error = [Microsoft][SQL Native Client]SQL 网络接口: 定位指定的 Server/Instance
时出错 [xFFFFFFFF].
SQLState = HYT00, NativeError = 0
Error = [Micros ......
Oracle数据库
SELECT
*
from
(
SELECT
ROWNUM AS NO_ROW
,row_.*
from
(
SELECT
&nb ......
alter table 表名
add constraint 约束名
foreign key(字段名) references 主表名(字段名)
on delete cascade
语法：
Foreign Key
(column[,...n])
references referenced_table_name[(ref_column[,...n])]
[on delete cascade]
[on update cascade]
注释：
column:列名
referenced_table_name:外键参考的主键� ......
*
sql xml 入门:
--by jinjazz
--http://blog.csdn.net/jinjazz
1、xml: 能认识元素、属性和值
2、xpath: 寻址语言，类似wind ......
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 ......
