SQL
peterpansh
等写
展开
-
sqlserver ( Limit )
select count(*) as n from tblcontact where email= and officeid_fk in --select count(*) as n from tblcontact where email= and firstname= and lastname= and officeid_fk in ( select officeid_pk fr原创 2006-01-04 11:24:00 · 3623 阅读 · 0 评论 -
TRUNCATE TABLE table1
TRUNCATE TABLE table1原创 2006-01-06 15:59:00 · 1138 阅读 · 0 评论 -
左右连接
select a.userid ,b.url from tbluser a right outer join tblurl b on a.userid=b.useridselect a.userid ,b.url from tbluser a inner join tblurl b on a.userid=b.userid原创 2006-03-24 11:06:00 · 737 阅读 · 0 评论 -
查询子节点
select treename ,(select count(*) from tbltree where treename like rtrim(a.treename)+%)-1 as 子节点数from tbltree a原创 2006-03-23 17:08:00 · 878 阅读 · 0 评论 -
RESTORE 数据库
backup database treex to disk=c:/treex.bak create database treexyz RESTORE DATABASE treexyz FROM DISK = c:/tree.bak WITH MOVE tree_Data TO C:/Program Files/Microsoft SQL Server/原创 2006-03-24 14:33:00 · 1017 阅读 · 0 评论 -
删除记录获取影响记录数
select @@ROWCOUNT原创 2006-06-09 15:50:00 · 967 阅读 · 0 评论 -
mysql 时间函数
http://fanqiang.chinaunix.net/a2/b1/20010705/150000802.html 首页 > 数据库 > MySQL > 正文原创 2006-12-06 14:53:00 · 657 阅读 · 0 评论 -
mysql 添加用户
GRANT Select, Insert, Update, Delete, Index, Alter, Create, Drop, References ON test.* TO peter@% IDENTIFIED BY 111111 UPDATE user SET Password = OLD_PASSWORD(111111) WHERE User = peter原创 2006-12-06 15:18:00 · 692 阅读 · 0 评论 -
EXEC master..xp_cmdshell 'bcp inzool.dbo.Out_Dv_Topic out c:/temp1.xls -c -q -S"127.0.0.1" -U"sa" -P"111111"'
EXEC master..xp_cmdshell bcp inzool.dbo.Out_Dv_Topic out c:/temp1.xls -c -q -S"127.0.0.1" -U"sa" -P"111111"原创 2007-04-06 14:59:00 · 1837 阅读 · 0 评论