- 博客(4)
- 资源 (1)
- 收藏
- 关注
原创 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
原创 左右连接
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
原创 查询子节点
select treename ,(select count(*) from tbltree where treename like rtrim(a.treename)+%)-1 as 子节点数from tbltree a
2006-03-23 17:08:00 878
原创 Request.ServerVariables("REMOTE_ADDR") 来取得客户端的IP 地址
Request.ServerVariables("REMOTE_ADDR") 来取得客户端的IP 地址
2006-03-16 00:18:00 4512 2
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人