http://www.knowsky.com/article.asp?typeid=19 SQL技巧 rss zh-cn Copyright 2000-2011 www.knowsky.com knowsky/19http://feedburner.google.comhttp://www.knowsky.com/555445.htmlwww.knowsky.comSQL技巧2011-10-20这段时间在看SAAS方面的书籍时发现一个关于数据处理的问题。里面讲到一种扩展性非常好的方法。但一直到今天终于在网上找到了。只可惜现在还在探索，只是找到一个例子而已。我在这里把共享希望对大家有用。下面.....<a href='http://www.knowsky.com/555445.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a> <p><a href="http://feedads.g.doubleclick.net/~a/UjX7JM3A-lNaODJBvbiEFLhbf0w/0/da"><img src="http://feedads.g.doubleclick.net/~a/UjX7JM3A-lNaODJBvbiEFLhbf0w/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/UjX7JM3A-lNaODJBvbiEFLhbf0w/1/da"><img src="http://feedads.g.doubleclick.net/~a/UjX7JM3A-lNaODJBvbiEFLhbf0w/1/di" border="0" ismap="true"></img></a></p>http://www.knowsky.com/555147.htmlwww.knowsky.comSQL技巧2011-09-26SQl server data dictionary1 insert usage by using select keyword --插入表的方法insert into testa select.....<a href='http://www.knowsky.com/555147.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a> <p><a href="http://feedads.g.doubleclick.net/~a/UyyYPyu1HmIGmSHfHAeumIEgUAk/0/da"><img src="http://feedads.g.doubleclick.net/~a/UyyYPyu1HmIGmSHfHAeumIEgUAk/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/UyyYPyu1HmIGmSHfHAeumIEgUAk/1/da"><img src="http://feedads.g.doubleclick.net/~a/UyyYPyu1HmIGmSHfHAeumIEgUAk/1/di" border="0" ismap="true"></img></a></p>http://www.knowsky.com/555146.htmlwww.knowsky.comSQL技巧2011-09-26&nbsp;今天才发现sql server 里面也有哈希索引，真是罪过。用数据库这么久了。还是进入正题吧～～下列示例显示使用 CHECKSUM 生成哈希索引。通过将计算校验和列添加到索引的表中，然后.....<a href='http://www.knowsky.com/555146.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a> <p><a href="http://feedads.g.doubleclick.net/~a/bH_lQ4iG4T2pOP4juA1m1An7W7w/0/da"><img src="http://feedads.g.doubleclick.net/~a/bH_lQ4iG4T2pOP4juA1m1An7W7w/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/bH_lQ4iG4T2pOP4juA1m1An7W7w/1/da"><img src="http://feedads.g.doubleclick.net/~a/bH_lQ4iG4T2pOP4juA1m1An7W7w/1/di" border="0" ismap="true"></img></a></p>http://www.knowsky.com/555144.htmlwww.knowsky.comSQL技巧2011-09-261、内存使用分类 按用途分类1）Database cache（数据页面）。SQL Server中的页面都是以8KB为一个页面存储的。当SQL Server需要用到某个页面时，它会将该页面读到内存中.....<a href='http://www.knowsky.com/555144.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a> <p><a href="http://feedads.g.doubleclick.net/~a/L8rWnUIjZ5uGFZB5Kou28Hds-ac/0/da"><img src="http://feedads.g.doubleclick.net/~a/L8rWnUIjZ5uGFZB5Kou28Hds-ac/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/L8rWnUIjZ5uGFZB5Kou28Hds-ac/1/da"><img src="http://feedads.g.doubleclick.net/~a/L8rWnUIjZ5uGFZB5Kou28Hds-ac/1/di" border="0" ismap="true"></img></a></p>http://www.knowsky.com/555140.htmlwww.knowsky.comSQL技巧2011-09-26关于Insert字符串很多同学都在这个方面发生了问题，其实主要是因为数据类型和变量在作怪。下面我们就分别讲述，虽然说的是Insert语句，但是Select、Update、Delete语句都是一样的。.....<a href='http://www.knowsky.com/555140.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a> <p><a href="http://feedads.g.doubleclick.net/~a/oOJVafrfuhX7tpgei8pj9440CXw/0/da"><img src="http://feedads.g.doubleclick.net/~a/oOJVafrfuhX7tpgei8pj9440CXw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/oOJVafrfuhX7tpgei8pj9440CXw/1/da"><img src="http://feedads.g.doubleclick.net/~a/oOJVafrfuhX7tpgei8pj9440CXw/1/di" border="0" ismap="true"></img></a></p>http://www.knowsky.com/555048.htmlwww.knowsky.comSQL技巧2011-09-20left join(左联接) 返回包括左表中的所有记录和右表中联结字段相等的记录 right join(右联接) 返回包括右表中的所有记录和左表中联结字段相等的记录inner join(等值连接) .....<a href='http://www.knowsky.com/555048.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a> <p><a href="http://feedads.g.doubleclick.net/~a/6UZNkuQZ-Y4-FVd6hJIlo90dRj4/0/da"><img src="http://feedads.g.doubleclick.net/~a/6UZNkuQZ-Y4-FVd6hJIlo90dRj4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/6UZNkuQZ-Y4-FVd6hJIlo90dRj4/1/da"><img src="http://feedads.g.doubleclick.net/~a/6UZNkuQZ-Y4-FVd6hJIlo90dRj4/1/di" border="0" ismap="true"></img></a></p>http://www.knowsky.com/555047.htmlwww.knowsky.comSQL技巧2011-09-20查询： Sql代码&nbsp; select * from table_name 删除： Java代码&nbsp; delete from table_name where 条件&nbs.....<a href='http://www.knowsky.com/555047.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a> <p><a href="http://feedads.g.doubleclick.net/~a/jKKnKKEoRM7xYnhAH9NNbjK6iLg/0/da"><img src="http://feedads.g.doubleclick.net/~a/jKKnKKEoRM7xYnhAH9NNbjK6iLg/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/jKKnKKEoRM7xYnhAH9NNbjK6iLg/1/da"><img src="http://feedads.g.doubleclick.net/~a/jKKnKKEoRM7xYnhAH9NNbjK6iLg/1/di" border="0" ismap="true"></img></a></p>http://www.knowsky.com/555045.htmlwww.knowsky.comSQL技巧2011-09-20DATEADD(day,-6,Duetime) &lt;= GETDATE() &nbsp; &nbsp; //在DataView中排序&nbsp;&nbsp;&nbsp;&nbsp;&nbsp.....<a href='http://www.knowsky.com/555045.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a> <p><a href="http://feedads.g.doubleclick.net/~a/gcViiUut9DAiQgRQiuxyOOuZC2k/0/da"><img src="http://feedads.g.doubleclick.net/~a/gcViiUut9DAiQgRQiuxyOOuZC2k/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/gcViiUut9DAiQgRQiuxyOOuZC2k/1/da"><img src="http://feedads.g.doubleclick.net/~a/gcViiUut9DAiQgRQiuxyOOuZC2k/1/di" border="0" ismap="true"></img></a></p>http://www.knowsky.com/552460.htmlwww.knowsky.comSQL技巧2011-05-15最近在一个做企业的一个内部系统，数据库采用的是SQL2000，为了保证数据的安全性，需要每天下班之后做数据备份，并且通过邮件的方式通知管理员备份情况。备份数据库很简单，用SQL代理建立一个作业，每天.....<a href='http://www.knowsky.com/552460.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a> <p><a href="http://feedads.g.doubleclick.net/~a/VITx-KUwqx8qg4oznt0hbn92ZjM/0/da"><img src="http://feedads.g.doubleclick.net/~a/VITx-KUwqx8qg4oznt0hbn92ZjM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/VITx-KUwqx8qg4oznt0hbn92ZjM/1/da"><img src="http://feedads.g.doubleclick.net/~a/VITx-KUwqx8qg4oznt0hbn92ZjM/1/di" border="0" ismap="true"></img></a></p>http://www.knowsky.com/552240.htmlwww.knowsky.comSQL技巧2011-05-05LINQ 语言集成查询（Language INtegrated Query）作为.net平台的一项查询技术，给我们的开发带来了极大地方便。本人用2.0的平台时间较长，对LINQ用的不是太多。LINQ.....<a href='http://www.knowsky.com/552240.html'>点击浏览详细内容</a><br/><br/>-------------------------------------<br/>导航:<a href='http://www.knowsky.com/developer.asp' target='_blank'>编程</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/zhanzhang.asp' target='_blank'>站长</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/web.asp' target='_blank'>网页</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/photo.asp' target='_blank'>图形</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/system.asp' target='_blank'>系统</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/internet.asp' target='_blank'>冲浪</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/qq.asp' target='_blank'>QQ</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/soft.asp' target='_blank'>软件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/office.asp' target='_blank'>办公</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/shoujixueyuan.asp' target='_blank'>手机</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/mailserver.asp' target='_blank'>邮件</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/networksecurity.asp' target='_blank'>安全</a>&nbsp;&nbsp;<a href='http://www.knowsky.com/exam.asp' target='_blank'>认证</a> <p><a href="http://feedads.g.doubleclick.net/~a/9ntKebCUkpsdbDzg1DjRJPbILCU/0/da"><img src="http://feedads.g.doubleclick.net/~a/9ntKebCUkpsdbDzg1DjRJPbILCU/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/9ntKebCUkpsdbDzg1DjRJPbILCU/1/da"><img src="http://feedads.g.doubleclick.net/~a/9ntKebCUkpsdbDzg1DjRJPbILCU/1/di" border="0" ismap="true"></img></a></p>